SUMMARY:

• Over 28 years of industry experience, with over 14 years of MS SQL Server / Oracle Development experience in Health - care, Insurance, Finance, Telecommunications, and Manufacturing (avionics and Motor Industry) domains with expertise in MS SQL Server 2008 and MS SQL Server 2012 suite of products like SSIS, SSAS, and SSRS, Oracle 11g, MS Silverlight 4.0.
• Experienced in architecting the ETL project (Data Extraction, Transformation and Loading) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2008/2012 respectively. Manage SSRS environment including user access, automating / scheduling reports, SharePoint Integration for SSRS
• Expert in Creating, direct Configuring configuration or development of BI dashboards and reports by using SSRS and also involved in Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expertise in Developing and Extending MS SQL Server Analysis Services 2012 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects and writing MDX queries.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008/2012 (SSRS), Crystal Reports XI.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Strong experience in Stored Procedure/TSQL and PL -SQL coding, performance Tuning and Query Optimization. Conducts ad-hoc analysis and studies for the business as needed in ORACLE 11g as well as SQL server Database. Prepares activity and status reports for active projects as required.
• Highly proficient in T-SQL and PL-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity and SQL joins.
• Involved in all phases of software development life cycle: design, implementation and testing. In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Expert in database creation, maintenance, monitoring, backups and recoveries. Specialized in analyzing, coding, implementing and creating complex query reports using Oracle 9i/ 10g/11g, SQL Server 2000/2005/2008 and DB2. Experience on Service & quality management tools such as Remedy, JIRA, Mercury QC, and Clear Quest. Experience on configuration management tools such as Clear Case and VSS, PVCS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages. Good understanding on .NET framework especially in ASP.NET client/Server technology.
• Experience in working multiple projects and complex engineering activities while balancing priorities and schedules

TECHNICAL SKILLS:

HARDWARE: IBM PC/compatibles, windows XP, IBM AIX, HP6200, Dec alpha UNIX machine, sun Solaris Server, Subversion, Windows NT/XP, MS windows

SOFTWARE: MS Sql-server 2012/2008/2005, MS Visual Studio 2010, T-SQL, Silverlight 4.0, ODBC, DTS, SSAS, SSIS, SSRS, Ibatis Framework, hibernate framework, Crystal Reports XI, Business Object XI, MS Access 2010, Excel, MS Visio, Erwin Platinum, HTML, XML, Windows NT/2000/XP/2007 server, Subversion, Unix, ADA, Python, C, C#, ADA 95, Visual Basic, OpenGL, HTML, ASP .NET, Java, J2ee, Oracle 9i/10g, TCP/IP, API, Flash, Doors, MS Project, MS Office, Ftp and Visio, PDM Data warehouse, Clear-case, UML, Business Process Workflow, Use Case, Eclipse

PROFESSIONAL EXPERIENCE:

Confidential

Project Leader/Sr. Software Engg

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Primary responsibilities include design, development, testing, deployment, support and reporting of Center for Medicare/Medicaid system (CMS) for the USA government Agency.
• Perform database administration and development, as well as web development. Also involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2008 and MS SQL Server 2012 respectively. Manage SSRS environment including user access, automating / scheduling reports, SharePoint Integration for SSRS.
• Involved in Creating, direct Configuring configuration or development of BI dashboards and reports by using SSRS and also involved in Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Work with the business to add functionality to existing databases in production.
• Developed various Cubes by using SSIS and SSAS services and also created various reports (drill down, summary, graphs, charts) by using SSRS reporting services.
• Involved in successful production implementation of the project. Also involved in successful production implementation of the project & configuration of the system in Lawson environment.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Environment: Oracle 11g, SQL Server 2012/2014 Enterprise, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services, Visual Studio 2010, C#, ASP, .NET, Sqr, Crystal Reports XI, Toad, Application Manager, Oracle 11g, Excel spreadsheet, xml tree, java, j2ee, crystal reports,Visio, MS Project, Ms.-access 2010, MS Office, insight, EDI, Import manager.

Confidential

Sr. Lawson Developer/Database Admin.

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Primary responsibilities include design, development, testing, deployment, support and reporting of Financials and also involve in updating of EPIC Patient applications under Lawson 9x System
• Responsibilities include development of reporting system by using Crystal Reports for ERP Financial upgrade for the Modules, such as; Hospital management system, Payroll, General Ledger, HR/benefit, Supply Chain, A/R, A/P, PO/PC, Billing system, Purchasing, e-procurement and also Involved in Integration testing and Configuration of the financial system.
• Gathered and shared report options with clients. Prepared Crystal Reports as well Tableau reporting, MS SSRS reporting - time estimates and Supported and maintained current Crystal Reports as well Tableau and MS SSRS reporting. Responded quickly to report modification requests.
• Translated end user requirements into design documents. Designed reports to provided technical specifications. Upheld best coding standard practices. Mapped data between external databases and Crystal Reports.
• Involved in successful production implementation of the project. Also involved in successful production implementation of the project & configuration of the system in Lawson environment.
• Coordinating integration of Software Components for data conversion, Participates in requirement gathering and conducted Business meetings for issues related to conversions, Interfaces and customizations.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Environment: SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services, Visual Studio 2010, C#, ASP, .NET, Sqr, Crystal Reports XI, Toad, Application Manager, Oracle 11g, Excel spreadsheet, xml tree, java, j2ee, crystal reports, spufi, Visio, MS Project, Ms.-access 2010, MS Office, insight, EDI, Import manager.

Confidential, IA

ETL Architect

Responsibilities:

• Managing, maintaining, developing and deploying applications and databases in response to business needs.
• Perform database administration and development, as well as web development. Also involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2008 and MS SQL Server 2012 respectively. Manage SSRS environment including user access, automating / scheduling reports, Sharepoint Integration for SSRS
• Involved in Creating, direct Configuring configuration or development of BI dashboards and reports by using SSRS and also involved in Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Work with the business to add functionality to existing databases in production.
• Developed various Cubes by using SSIS and SSAS services and also created various reports (drill down, summary, graphs, charts) by using SSRS reporting services.
• Manage small-to-medium-sized projects for Domains/ Web developments, payment gateway integrations, interfacing with other applications. Support of existing applications, with phone support and other interaction with our clients.

Environment: Visual Studio 2010, C#, ASP, .NET, Sqr, Crystal Reports XI, SQL-Server 2012, SQL/Plus, Toad, Application Manager, Oracle 10g, SQL, excel spreadsheet, xml tree, java, j2ee, crystal reports, spufi, Visio, MS Project, Ms.-access 2008, MS Office, insight, edi, import manager.

Confidential

Sr. Systems Engineer

• Responsibilities include architecting and designing the various migration Project from legacy systems to ASP .Net Platform with an Oracle 11g and SQL Server 2008 database on the backend.
• Involved in developing Stored Procedure/TSQL coding, Performance Tuning, and Query Optimization. Conducts ad-hoc analysis and studies for the business as needed in ORACLE as well as SQL server Database. Prepares activity and status reports for active projects as required.
• Implemented/migrated data from various different platform into a new Oracle application by using Informatica 9.0. Gather the new requirements for data integration. Involved in supporting the daily data movement. Informatica Data Archive improves application performance with large data volumes in key transaction tables through the use of Smart Partitioning.
• Involved in database administration and development - coordinated with businesses to improve the current system and add new functionalities to existing databases in production in the environment using DTS and SSIS, SSAS and SSRS of MS SQL Server 2008 and MS SQL Server 2008 respectively.
• Design and developed various Cubes by using SSIS and SSAS services of Sql server2008 and also created various reports (drill down, summary, graphs, charts) by using SSRS reporting services.

Environment: MS SQL Server 2000/2008, Informatica 9.4,SQL server Reporting Services 2008, Silverlight 4.0, SQL Analysis Server 2008,Crystal Reports XI, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Visual Basic, C#, ASP, .NET, Sqr, Crystal Reports XI, SQL-Server 2007, SQL/Plus, Toad, FoxPro, Oracle 11g, UML, Business Process Workflow, Use case, API, CMMI, Six-Sigma Methodology, C/C++, SQL/Plus, Toad, UML, MS-Access 2010, QMF, Mercury Test Director, API, BMC Software, SAP, PeopleSoft 8.4, SQR, people tool.

Confidential

Sr. Software Engineer

• The primary objective of this project to build a robust and intelligent system that will help Business people to strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from heterogeneous sources like Lotus Notes Databases, Oracle 10g, SQL Server 2000/2005. Provide maintenance support for ETL systems.
• Design and developed various Cubes by using SSIS and SSAS services of SQL -SERVER 2012 and also created various reports (drill down, summary, graphs, charts) by using SSRS reporting services.
• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP. Developed logical and physical data models, designed data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions. Created calculated measures and dimension members using multi dimensional expressions (MDX), mathematical formulas, and user-defined functions. Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).

Environment: Sql-server 2008, ASP, .NET, SQL, Ada 95, Python, Informatica 9.4,C/C++, C#,ADA 95, DO178B, AR INC 664, AR INC 429, Visual Basic, OpenGL, HTML Crystal Reports XI, SQL-Server 2000, SQL/Plus, Clear-case, Remedy Software, Oracle 9i, UML, Subversion, API,,Visual Studio, C#, Six-sigma methodology, PDM/Eng central, SAP, Subversion

Confidential

Sr. ERP Consultant (Sr. Software Engineer)

• Re-development of an existing VB 6.0 document management application into a VB.NET Win-Forms application with a SQL Server database on the backend. VB.NET application developed using the following layers: Presentation, Business Façade, Business Objects, Framework and Data. Redesigned SQL backend for new data structure and for Normalization.
• Upgraded MS SQL Server 2000 databases to 2005, using Detach/Attach, Back up & Recovery and by Replication. Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse. Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers. Created Views to reduce database complexities for the end users.

Environment: MS SQL Server 2000/2005, T-SQL, SQL Query Analyzer, Crystal Reports XI, ADA, Visual Basic, C#, ASP, .NET, Oracle 9i, UML, Business Process Workflow, Use case, C#, ASP .Net., Visual Basic 6.0, DB2, UML, FoxPro, Use case, MS-Access 2003, QMF, Mercury Test Director, API, BMC Software, Import Manager.