Stylianos Anestis

While working as an IT senior manager in 2013-2014, the client company bought an ERP program from Singular S.A. (www.singular.gr). Galaxy Enterprise Suite was the supporting ERP, and they also bought the Galaxy CRM. Working as a CRM analyst, I customized the programs in Dynamics CRM 2011 and SQL 2008.

I led a team of seven programmers to customize the CRM with new forms, campaigns, and code in VB.NET and T-SQL. We also wrote code in .NET for their old files and then transferred them to the new CRM version. This project is a good example of my experience in analyzing large databases with multimillion customers.

Key Activities:
• Used the Dynamics Sure Step methodology to deploy migrates, configure, and upgrade CRM 2011.
• Used a multi-server deployment plan.
• Set up CRM 2011 on-premises and supported it with Outlook.
• Transformed the data tables and fields with SSIS.
• Customized the existing forms and created new entities.
• Worked with accounts, customers, leads, contacts, orders, and products.
• Contributed to the direct marketing and contact strategy and campaign analytics.

In 2013-2014, I worked on client projects as a freelance developer through several Greek software houses.

Key Activities:
• Upgraded CRM 4.0 or CRM 2011 to CRM 2013 for 10+ customers.
• Transferred system data from CRM 4.0 or 2011 to 2013 for customers that moved to on-premise solutions. Made the necessary changes and wrote extra code.
• Created new dashboards.
• Customized entities, fields, and solutions.
• In some cases, upgraded data in an Azure environment.
• Created business process flows and combined them with field security, business rules, and workflows, which saved user time and increased user adoption. This included all the necessary changes to other CRM components.
• Worked with accounts, customers, leads, contacts, orders, and products.
• Customized a CRM system to integrate with the existing business systems.
• Wrote code from scratch in C# and .NET.

Working as a freelance CRM developer in 2010-2013, I managed a team of five programmers who developed code in parallel as if they were mini-projects. The developments were time-boxed, delivered, and then assembled into a working prototype. Following this method, we developed eight small custom applications in CRM 2011 and SQL 2008. The projects were for the retail market.

Key Activities:
• Assigned and maintained user accounts and security roles in CRM 2011.
• Created, edited, and used solution components.
• Created custom entities and modified existing ones.
• Created 1:N and N:N relationships and mapping option sets.
• Set up delivery partner commissions and invoicing.
• Set up data mining and reporting in SQL 2008.
• Collaborated with the implementation manager to ensure effective rollout of the project across 4,000 delivery partners.
• Worked with accounts, customers, leads, contacts, orders, and products.
• Co-created a platform for the loan recipient community.
• Performed quality management, data mining and reporting, and information security.

In cooperation with the Greece Manpower Employment Organization in 2008-2010, I constructed a custom CRM 2011 application, following an iterative model. As a project manager, I led a group of 10 IT members (six freelance and four officials). The duration of the project was 20 months, and the scope included design, implementation, analysis, training, and documentation.

After the design and programming of the new system, we had to transfer a large data set, which was in several old systems (SQL Server 7.0, Dbase, and RISC 6000), into one database. We wrote code in VB 6.0, VB.NET, ASP 3.0, and XML.

While working in a consulting company, TOP Management, in 2006-2008, I rolled up their system (SQL 2005 and .NET VB 2006) in many branches and in parallel to train their end users. I also customized the CRM 4.0 according to their needs. The companies were in the food and beverage industry.

Key Activities:
• Customized existing methodologies, forms, views, queries, and reports, creating new and/or similar ones, as needed.
• Changed role securities and users.
• Wrote code in XRM, T-SQL, and C#.NET as needed.
• Created custom workflow activities.
• Wrote queries, using T-SQL and assigned filtered views.
• Worked with accounts, customers, leads, contacts, orders, and products.

As a CRM Analyst, My primary role was to ensure that business processes and supporting systems continued to meet the needs of business project stakeholders. As a key liaison between the technical IT staff who implemented business system solutions and the line-of-business staff who performed the process work manually or in conjunction with automated systems, I was the primary contact and bridge between the IT and business domains.

Key Activities:
• Analyzed, programmed, and designed CRM applications.
• Participated in systems analyses and design studies for functional systems and design specifications.
• Maintained multiple IT systems that had different databases and used different programming languages and operating systems.
• Performed business analysis, business case creation, requirements gathering, and benefits tracking.
• Gathered and assessed business information needs and reporting requirements.
• Leveraged SQL experience, including writing scripts and pulling reports related to regression, confidence intervals, significance, and clustering or statistical families.