SUMMARY:

• Over Twelve (12) years of experience in developing large scale software systems including requirements gathering, database design (System/Database/OO), data modeling, ETL programming, testing and implementation (System/Database/OO) of application software in web - based environments, distributed N-tier and Client/Server architectures.
• Highly skilled and Microsoft Certified SQL Server professional, extensively involved in the design and development of dimensional modeling, multidimensional data model and relational database design including the creation of database objects, table partitioning, OLAP cubes, stored procedures, triggers, Queries, Indexes and performance tuning. Involved in design, develop and deploy of Business Intelligence solutions by using Microsoft SSIS and SSAS. Constructed data warehouse and designed data marts by using Star and Snowflake schemas. Extensively worked in ETL, SSIS (Microsoft SQL Server Integration Services) and OLAP technology (Microsoft SQL Server Analysis Services) for modeling data into meaningful, easy-to-navigate business information by creating star schema and data cubes that facilitates online business analysis and query performance. Designed, developed and optimized SQL Server stored procedures against a dimensional data warehouse to update fact and dimension tables. Star Schema design for DSS and MIS data marts, and cube modeling for advanced data mining initiatives.
• Strong problem solving, technical and analytical skills, with proven ability to work with people of all technical levels within the many project engagements referenced in the Engagement Overview section.

TECHNICAL SKILLS:

Development Software and Languages: MS SQL Server 2012/2008 R 2/2005/2000/7.0, SSAS, SSIS, Transact SQL, Triggers, Stored Procedures, Views, ORACLE 8i/9i/7.0, PL/SQL, SQL*PLUS, Developer 2000,, DB2, .NET (Data Grid, Win Forms, Tree View), Visual Basic 6.0, MS Access, Crystal Reports, Active Reports, C, UML, MS ADO 2.0/2.1/2.5/2.6, ADO.NET, HTML, ASP, OLAP (Microsoft Analysis Services)Other Software: Erwin, Visio, Microsoft Visual Source Safe, Crystal Reports, Active Reports, MS Office.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data warehouse/BI/ETL Developer

Environment: SQL SERVER 2012/2008 R2/2005 Stored Procedures, Triggers, Indexes, SSIS, SSAS, Enterprise Manager, MDX, ERWIN, VISIO, VISUAL SOURCE SAFE ENVIRONMENT.

Responsibilities:

• Design, Coding, Testing and Integration.
• Creating data warehouse schema.
• Designed template SSIS package.
• Designed the ETL Flow from the source to the warehouse.
• Data extraction Transformation and Loading (ETL).
• Design relational database objects like tables, views, and indexes using DDL
• Created Table Partitioning.
• Design and performance tune of queries, functions and stored procedures.
• Used Bulk Insert to copy a data file into a database table or view in a specified format .
• Design and Maintenance of Database.
• Development of stored procedures and triggers.
• Extensively involved in optimizing using query plan for better performance.
• Testing and Deployment of system on Server.

Confidential

Sr. ETL/Database Developer

Environment: WINDOWS XP, SQL SERVER 2005/2000, Stored Procedures, SSIS, SSAS, Triggers, Indexes, SSIS, SSAS, Enterprise Manager, ERWIN, Java, VISUAL SOURCE SAFE ENVIRONMENT.

Responsibilities:

• Creating data warehouse.
• Design, Coding, Testing and Integration.
• Design relational database objects like tables, views, and indexes using DDL
• Designing of SQL Scripts for reporting.
• Design and performance tune of queries, functions and stored procedures.
• Data extraction Transformation and Loading (ETL).
• Used Bulk Insert to copy a data file into a database table or view in a specified format .
• Design and Maintenance of Database.
• Development of stored procedures and triggers.
• Extensively involved in optimizing using query plan for better performance.
• Testing and Deployment of system on Server.

Confidential

Sr. ETL/Database Developer

Environment: WINDOWS XP, SQL SERVER 2000/2005, Stored Procedures, Triggers, Indexes, DTS, SSIS, SSAS, C#, Visual Studio.Net 2005, VISUAL SOURCE SAFE ENVIRONMENT.

Responsibilities:

• Design, Coding, Testing and Integration.
• Design relational database objects like tables, views, and indexes.
• Design and performance tune of queries, functions and stored procedures.
• Data extraction Transformation and Loading (SSIS).
• Used Bulk Insert to copy a data file into a database table or view in a specified format .
• Crested XML format file and used OPENROWSET with BULK option to load data.
• Design and Maintenance of Database.
• Development of stored procedures and triggers.
• Extensively involved in optimizing using query plan for better performance.
• Testing and Deployment of system on Server.

Confidential

Sr. ETL/Database Developer/Analyst

Environment: WINDOWS 2000/NT V4.0, VB.NET, WIN FORMS, DATA GRID, ADO.NET, SQL SERVER 2005/2000, Stored Procedures, Triggers, Indexes, MICROSOFT ANALYSIS SERVICES (OLAP), MDX QUERIES, MS ADO 2.5/2.6, ODBC 3.0/2.5, ACTIVE REPORTS, Excel PIVOT Table , VISUAL SOURCE SAFE ENVIRONMENT.

Responsibilities:

• Design, Coding, Testing and Integration.
• Interacting with users and analysis of user requirements.
• Design relational database objects like tables, views, indexes, procedures, triggers.
• Data extraction Transformation and Loading
• Used Bulk Insert to copy a data file into a database table or view in a specified format .
• Design and Development of various front end screens.
• Design and Maintenance of Database.
• Testing and Deployment of system on Server.
• Generation of Reports.

Confidential, State of Arkansas

Sr. System Analyst

Environment: WINDOWS 2000/NT V4.0, VISUAL BASIC 6.0, VB.NET, WIN FORMS, DATA GRID, ADO.NET, SQL SERVER 2000/7.0, MICROSOFT ANALYSIS SERVICES (OLAP), MDX QUERIES, MS ADO 2.5/2.6, ODBC 3.0/2.5, ACTIVE REPORTS, Excel PIVOT Table , VISUAL SOURCE SAFE ENVIRONMENT.

Responsibilities:

• Design, Coding, Testing and Integration.
• Interacting with users and analysis of user requirements.
• Design relational database objects.
• Design multidimensional data marts by using star and snowflake schemas
• Design OLAP dimensions based on underlying source data.
• Data ETL Development
• Decision Support and Operational design methodologies.
• Developed cubes with storage types MOLAP, ROLAP, HOLAP.
• Design and Development of various front end screens.
• Extensively used Win Forms and Data Grid for Information in a tabular format.
• Developing ActiveX Components in Visual Basic for Data extraction and Data loading into SQL Server Database
• Design and Maintenance of Database.
• Used Replication for copying and distributing data and database objects from one database to another.
• Development of stored procedures and triggers.
• Testing and Deployment of system on Server.
• Generation of Reports.

Confidential, Sate of Arkansas

Sr. System Analyst

Environment: Windows 2000, AIX, Mercury Load Runner, Visual Basic. Net, Win Forms, Data Grid, Crystal Reports, SAP Business Ware House, SAP R/3, Microsoft SQL, ABAP, Visual C#, SAP .Net, Connector, SQL Server 2000, Erwin data Modeling, Microsoft Analysis Services(OLAP).

Responsibilities:

• Actively involved in the Design, Development and Code Review of PBAS and Testing
• Created cubes, Designed OLAP dimensions based on underlying source data.
• Designed cube storage and aggregations.
• Update dimensions and cubes when source data changes.
• Optimize the processing of dimensions and cubes
• Used Microsoft Excel 2000 as an OLAP front-end application.
• Developing stored procedures and triggers
• Tuning of SQL and Used SQL Profiler for performance analysis
• Analyzed requirements to create design specs
• Extensively used Win Forms and Data Grid for Information in a tabular format.
• Generated reports using Crystal Reports for .NET as a Web Service.
• Development of the DAL using ADO.NET for data extraction and data loading into SQL Server database
• Design and Maintenance of database
• Development of stored procedures and triggers
• Application Tuning for efficiency
• Designing report generation application
• Testing

Confidential, State of Arkansas

Lead Developer

Environment: Windows 2000 with IE 5.5, MS Internet Information Services, COM + Server, IBM ES-9000VB, HTML, DHTML, XML, Visual Basic, VBScript, CICS, VS-COBOL II, MQ Series, Microsoft Interdev, MS Project, Microsoft VSS, DB2, MS SQL Server 7.0/2000, ERWIN, MS OLAP(Analysis services).

Responsibilities:

• Interacting with users and analysis of user requirements
• Created cubes, Designed OLAP dimensions based on underlying source data.
• Designed cube storage and aggregations.
• Update dimensions and cubes when source data changes.
• Optimize the processing of dimensions and cubes
• Used Microsoft Excel 2000 as an OLAP front-end application
• Design and Development of various screens
• Utilization of ActiveX Components for data extraction and loading into SQL Server database
• Design and Maintenance of database.
• Development of stored procedures and triggers and Application Tuning for efficiency
• Designing report generation application

Confidential, State of Arkansas

Lead Developer

Environment: WINDOWS 2000/NT V4.0, VISUAL BASIC 6.0, MS ADO 2.1/2.5, SQL SERVER 2000/7.0, ODBC 3.0/2.5, ACTIVE REPORTS, VISUAL SOURCE SAFE ENVIRONMENT.

Responsibilities:

• Design, Coding, Testing and Integration.
• Interacting with users and analysis of user requirements.
• Design and Development of various front end screens.
• Development ActiveX Components for database access.
• Design and Maintenance of Database.
• Development of stored procedures and triggers.
• Testing and Deployment of system on Server.
• Generation of Reports.

Confidential, State of Arkansas

Developer

Environment: 80486, WINDOWS NT V4.0/3.51, VISUAL BASIC 6.0/5.0, MS ADO 2.0/2.1, SQL SERVER 7.0/6.5, ODBC 3.0/2.5, VISUAL SOURCE SAFE 4.0 ENVIRONMENT

Responsibilities:

• Documenting application design specifications
• Application development

Confidential

Developer

Environment: 80486, WINDOWS NT V4.0/3.51, VISUAL BASIC 5.0/4.0, SQL SERVER 6.5/6.0, ODBC 3.0/2.5, CRYSTAL REPORTS, VISUAL SOURCE SAFE 4.0 ENVIRONMENT

Responsibilities:

• Documenting application design specifications
• Application development