Analyst and Developer Resume

SUMMARY

He is an Information Technology (IT) Professional with 17 years of successful experience with advanced level of development of Client Server applications.
He offers over 8 years of working experience in all the cycles of development in SQL server development life cycle, customization in the end users/business requirements, in design, Architecture, analysis and testing of Data warehouse using ETL tools, Data Modeling and OLAP tools.
He is experienced in all phases of the Software Development Life Cycle, analyst and solutions for the customs applications, client interaction, end user documentation and technical documentation.
He is an expert in Setting up, Configuring, Creating and Scheduling SQL Server Integration Services and Analysis Services and hands on experience in creating OLAP cubes.
He is experienced in enhancing and deploying the MS - SQL Server (SSIS) packages from development server production server. He has expertise in creating database, T-SQL scripts, stored procedures, views, tables, indexes and constraints, user function and security using MS-SQL Server 2008 r2/2005/2000; expert in migration of ETL packages using DTS from MS-SQL server 2000 to SSIS 2008 r2 and implementing all transformations available in the SSIS toolbox.
He has experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System (Excel, AS400, and Access).
He possesses a fair knowledge on .NET Framework methodology for understanding front-end applications and services.
He sets and achieves goals, works well under pressure and is bilingual (Spanish and English).

TECHNICAL SKILLS

Languages: PL/SQL, Visual Basic for Access, Visual Basic .NET, C#, XML, XSL, T-SQL

Software/Tools Share Point: Visual Studio 2010, Business Intelligence Studio (MS-SQL Server 2008-SSIS, SSAS, SSRS), BPCS, Monarch, Ultra Edit, MS Office 2010, VMWare, Vision

Operating Systems: Windows Server 2008, Windows 7

Methodologies: UML, Agile

PROFESSIONAL EXPERIENCE

Confidential

Analyst and Developer

Responsibilities:

Analysis, Design and normalization of life cycle for new customers, CRM email and After Sales process and databases.
Creation of SSIS packages loading Flat files, tables, transformation fields, Emails develop on Visual Studio 2015.
Develop using C# for SSIS packages scripts.
Use of T-SQL, creation of store procedures, scripts for SQL Server 2008, 2012 and 2016.
Interview candidates for the Data Services team. Orientation and Training on the Data Services operations.
Creating start schemas for the Data warehouse.
Use of API calls and Rest calls. Use of JSON and XML.
Manage multiple accounts like Ford, Audi, Mazda and KIA with different marketing projects, process and data operations.
Replication data in other servers, using SSIS packages - ETL

Confidential, Detroit, MI

Applications Developer

Responsibilities:

Analysis and normalization of application system ESRD with the database. Front End developed on Access and Database design and normalization on SQL Server 2012. Creation of SSIS packages loading Flat files, tables, transformation fields, Emails
Maintenance for Dimensional Tables using a Start Model using SSAS
Develop using VBA and C# for SSIS packages scripts.
Use of T-SQL, creation of store procedures, scripts for SQL Server 2008 and 2012

Confidential - Detroit, MI

SSIS Developer

Responsibilities:

SQL Server 2012, writing store procedures, scripts, SSIS packages, ETL, DataMart snowflake schema.
KPI calculations with store procedures and scripts using TSQL.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship