SUMMARY:

• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Hands on experience with Erwin to forward and reverse engineer data models.
• Accommodating and facilitating Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.
• Highly proficient in the use of T - SQL for developing and debugging complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Implemented various integrity constraints to ensure entity, referential and domain integrity using Primary key and foreign key relationships as well as Check, Not Null and Unique constraints.
• Efficiently monitored and tuned the performance of Complex T SQL scripts by analyzing the execution plan and also using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Automated administrative tasks using SQL Agent, event notifications developed maintenance plans like back up databases, check database integrity, and scheduled maintenance plans according to Microsoft best practices.
• Highly Proficient in writing scripts and batches for carrying out database backups
• Experience in Installing, configuring, and monitoring and maintaining databases in the production, development, and quality assurance environments.
• Actively involved in the enterprise Data Warehouse designing using Kimball design methodologies and following DW Design best Practices.
• Extensive experience in staging DB design, Data Warehouse analysis, ETL strategies, and design of optimal and efficient OLAP cube strategies based on infrastructure as well as cube size.
• Designed high level ETL architecture for overall data transfer with the help of SSIS from the OLTP to OLAP.
• Used different tools like DTS/SSIS, BCP and BULK INSERT for the implementation of ETL strategies.
• Migration data from Oracle, Flat file, Excel to Microsoft SQL Server by using SSIS and DTS utility
• Extended SSIS packages with Script Components and Script Task Using .Net Languages.
• Worked with XML and SQL table configurations for modifying the SSIS Packages from a test/development environment to the production servers for day to day operation.
• Proficient in developing, maintaining and optimizing multidimensional cubes from data warehouse using SQL Server Analysis Services.
• Optimized large cubes by creating partitions, usage based optimizations and using proper storage modes like MOLAP, HOLAP and ROLAP
• Good understanding of various cube objects KPIs, Calculated Members, Perspectives, and Actions.
• Expert in creating and modifying the SSAS navigation and aggregation hierarchies which will provide significant improvement in analysis and report drill down.
• Experienced in generating reports like tabular, matrix, parameterized, sub reports, drill down and drill through reports and developed complex stored procedures for various kinds of reports using SSRS.
• Experience with the formatting of reports for various visual representations using conditional formatting and templates.
• Proficient in using Report manager to set up roles and security on the reports.
• Hands-on experience of setting up schedules for push and pull delivery methods for SSRS reports.
• Highly motivated with excellent inter personal skills and communication skills and ready to take challenges with proven ability.
• Experience in using PowerPivot to import data from various sources like Access, SQL Server and Excel
• Experience in using C#.net to increase the scope of my SSIS packages in order to solve the problems that couldn’t be solved by just using native SSIS
• Experience in using VB.net to increase the scope of my SSIS packages in order to solve the problems that couldn’t be solved by just using native SSIS
• Experience in using .Net to create Web services
• Experience in using .Net to creating Service Layers using C# and WCF.
• Experience in Implementing HTTP protocol and SSL to secure the information between WCF Service and Client.
• Experience in developing code to validate the user credentials for authenticating user to access the WCF service.
• Experience in writing C# code to create XML messages and send the messages to an IBM Message Que
• Limited experience in writing NoSQL queries using the salesforce developer console
• Experience in adding and deleting records from salesforce tasks using the UI
• Experience in performing hard deletes from salesforce tasks using the recycle bin
• Experience in monitoring and troubleshooting bulk jobs using the UI
• Experience in reading huge volumes of data from salesforce using various API tools like SSIS
• Some experience in using Microsoft BizTalk to help integrate software applications that were developed using different platforms

TECHNICAL SKILLS:

DATABASES: Microsoft SQL Server 2000, 2005, 2008, 2012, 2014 Netezza

DATABASE TOOLS Management Studio, Profiler, ER: Win, SIEBEL UCM, SIEBEL CRM, SALESFORCE

DATABASE LANGUAGES: SQL, T - SQL, Netezza SQL, Oracle SQL Developer

BUISNESS INTELLIGENCE: BIDS, SSIS, SSAS, SSRS

DATABASE MODELING: ER-Diagrams, Dimensional Diagrams, Star and Snowflake Schemas

PROGRAMMING LANGUAGES: C, C++, C#, .NET, BIZTALK

PROCEDURAL LANGUAGES: C, C++, Java, PHP

WEB LANGUAGES: HTML, XML, ASP.NET

OPERATING SYSTEMS: Windows XP, Windows 2000/2003/2008 Server

SOFTWARE ENVIRONMENTS: Microsoft Visual SourceSafe (VSS), IBM Message QUE

AGILE: Rally

WORK EXPERIENCE:

Confidential, St. Louis, Missouri

Database Developer

Responsibilities:

• Design and Develop ETL solutions using SSIS 2008/2013 tools that would perform an Initial load of customer relationship information from the existing Siebel CRM database in production to various tasks in Salesforce (Cloud database used by Confidential )
• Created Stored procedures, functions, tables and views using SQL Management Studio 2008/2012 that would transform data from SIEBEL CRM to the specified business requirements before loading the transformed data to the SalesForce database
• Created SQL Agent jobs that would be used to execute the ETL processes created
• Co-ordinate with other Agile team business analyst members on how to come up with the best possible solutions for any road blocks encountered in the project
• Creating User stories to define the roadmap for each new upcoming sprint
• Created ETL Packages extract back the data previously loaded into SalesForce tasks and compare it to the data in our staging database to make sure all the records sent to SalesForce actually made it there
• Used SSIS to load files containing account information from Confidential to the SQL staging database that would later be used for look up information during the transformation process.
• Performed rigorous code reviews of other developers’ code and ETL packages to make sure that they met the company’s coding standards and did not cause problems for the existing code in production.
• Used Microsoft SharePoint for information storage and sharing i.e. technical specifications, business requirements, project reports etc.
• Used Rally for story creation and sharing
• Involved in all project stand ups and meetings

Confidential

Database Developer

Responsibilities:

• Design and Develop ETL solutions using SSIS 2008/2013 tools that would perform an Initial load of customer and account information from the existing Siebel UCM database in production to a new Siebel UCM database specifically designed to be used by the Actimize tool.
• Design and develop ETL solutions using SSIS 2008/2013 that would perform daily delta loads of customer, bank and brokerage account information from the existing Siebel UCM database in production to the new UCM database designed for Actimize.
• Created Stored procedures, functions, tables and views using SQL Management Studio 2008/2012 that would transform data from the old SIEBEL UCM to the specified business requirements before loading the transformed data to the new SIEBEL UCM database for Actimize.
• Created SQL Agent jobs that would be used to execute the ETL processes created
• Co-ordinate with other Agile team business analyst members on how to come up with the best possible solutions for any road blocks encountered in the project
• Documenting Technical specifications at the end of every agile sprint
• Working with Actimize developers and other business segments to better define project requirements for development and implementation.
• Creating User stories to define the roadmap for each new upcoming sprint
• Used C# to create XML messages that would later be sent to the IBM Message Que
• Created ETL Packages to migrate data from CRI files to Sibel UCM and IBM Message Que
• Performed rigorous code reviews of other developers’ code and ETL packages to make sure that they met the company’s coding standards and did not cause problems for the existing code in production.
• Used Microsoft SharePoint for information storage and sharing i.e. technical specifications, business requirements, project reports etc.
• Used Rally for story creation and sharing
• Involved in all project stand ups and meeting

Environment: Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008, Microsoft SQL Server 2012, Microsoft SQL Server 2014, Integration Services 2008/2012/2013 , Management Studio, BIDS, SharePoint 2013, Visual Studio 2010, Microsoft Team Foundation Server 2008/2013. IBM Message Que, Actimize, Oracle SQL Developer, SIEBL UCM, Rally, SIEBEL CRM, SalesForce

Confidential, West Lake, Ohio

Software Developer

Responsibilities:

• Working with business segments to better define project requirements for development and implementation.
• Translate business requirements into technical specifications
• Developing code in .NET, SQL server to assist the developers.
• Working with Project Managers, Engineers, Business Analysts, Quality Assurance analysts and other team members to ensure that project obstacles and issues were addressed in a swift manner.
• Perform data maintenance which includes data transfers, data migration and data merging.
• Using different tools like DTS/SSIS, BCP and BULK INSERT for the implementation of ETL strategies
• Working with XML and SQL table configurations for modifying the SSIS Packages from a test/development environment to the production servers for day to day operation.
• Identify, document, and expedite resolution of functionality issues by performing debugging of software programs.

Environment: Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008, Microsoft SQL Server 2012, Integration Services, Management Studio, BIDS, SharePoint, Visual Studio 2010, Microsoft Visual SourceSafe (VSS)

Confidential, Cleveland, Ohio

Application Developer

Responsibilities:

• Created so many stored procedures to help improve business processes within and outside the company.
• Re-documented all the current business processes in production that were poorly documented or were not documented at all by past developers and business analysts.
• Created simple ETL solutions using BIDS and SQL Server management studio 2005, 2008, 2008 R2 to manipulate, load and transform data from different sources like flat files, Excel and OLE DB into meaningful information for the company
• Used Visual C# 2010 to create customized SSIS control flow components that could be used by anybody to simplify their work.
• Was heavily involved in Migration meetings and plans. By this I mean, that once someone finished developing a solution, we would create a migration plan on how it should be migrated from the development environment to the testing environment and finally to production. The plan would include tasks such as what configurations scripts should be run in the testing or productions environment, what scripts should be run before the packages are deployed, what objects should be present in the test or production environment before the plan is executed etc.
• Re-developed older SSIS packages in order to bring them up to current company standards, most especially the packages that were used to implement billing solutions.
• Helped in the documentation of business requirements for various projects not just BIDS projects
• Worked with SQL configurations in order to make it easier for SSIS solutions to be moved from one environment to another

Environment: Microsoft SQL Server 2008 R2, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Integration Services, Management Studio, BIDS, SharePoint, Visual Studio 2010, Microsoft Visual SourceSafe (VSS)

Confidential, Milwaukee, Wisconsin

SQL/SSIS-ETL Developer

Responsibilities:

• Created T-SQL batches using Aginity in order to extract data from the Bank Data warehouse that was stored in a netezza platform, transform the data using SSIS according to the business requirements and then load it to different database destinations for further analysis.
• Analyzed data in the Data warehouse in order to solve any defects that were created in the data by previous developers
• Analyzed Current ETL solutions that had been implemented by previous SSIS developers in order to modify them to meet the changing requirements of the Bank
• Analyzed Current ETL solutions developed by my team mates in order to correct the defects that were in the packages there by causing defects in the data that was being migrated.
• Created SSIS packages that would extract data from the Bank Data warehouse and other databases and created comma delimited files which would in turn be sent to the federal government
• Created and set up ETL jobs using SQL Server Agent for executing SSIS packages
• Debugged existing ETL jobs in order fix defects that were appearing in the data after it had been migrated
• Communicated with the team members on regular basis about the change requests that had to be made for all the implementations
• Optimized existing queries written in Netezza SQL in order to improve performance in various SSIS packages

Environment: Microsoft SQL Server 2008 R2, Aginity, IBM Netezza, Integration Services, Reporting Services, Management Studio, BIDS, SharePoint, Visual Studio 2010

Confidential, Sacramento, California

SQL/ETL-SSIS Developer

Responsibilities:

• Used Microsoft SQL Server 2008 to design and implement an OLTP database meant for tracking transactions about phone carriers and their respective customers
• Created objects such as: Stored Procedures, Triggers, User define functions, Indices, Views, and Index views in order to create a pipe delimited result set that would be taken in as input by the script component in SSIS and written to a flat file.
• Created T-SQL batches and database Scripts used for backing up and restoring the database
• Designed Tables, Table Partitions, and Indexes in order to optimize the performance of stored procedures.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Optimized the embedded application T-SQL code as well as the stored procedures used to create pipe delimited output files for all the phone carriers
• Worked on MDX queries to create calculated members, KPI (Key Performance Indexes) and deployed them on SSAS Server using XMA script.
• Managed the entire ETL process involving the staging of input records from different phone carriers and the creation of pipe delimited output files for those phone carriers.
• Used different advanced features of SQL Server 2008 R2 in TSQL like Pivot and Un-Pivot for Enterprise reporting and ad-hoc reporting.
• Worked on MERGE keyset that would allow inserting, updating and deleting in an optimized way in very short period of time.
• Developed complex mappings using SSIS to transform and load the data from flat file sources
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Developed drilldown, drill-through, and parameterized reports using SSRS to present information from data marts to the end users at Confidential in a well-organized way
• Developed and implemented properly the backup and disaster recovery procedures.
• Trained the new IT DB staff on administration, replication, backup and restore of relational databases, specifically Microsoft SQL Server 2008.
• Responsible for Windows Server (2008 R2) configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems.
• Installed, configured, monitored and maintained databases in the production, development, and quality assurance environments.

Environment: Microsoft SQL Server 2008, Integration Services, BIDS

Confidential, Newark, New Jersey

SQL/ETL-SSIS/.NET/BizTalk Developer

Responsibilities:

• Designed and implemented OLTP database using Microsoft SQL Server 2005.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indices, Views, and Index views.
• Developed T-SQL batches and database Scripts to populate the tables in the database schema.
• Involved in the creation of Table Partitions, and Indexes for performance tuning and optimization of SQL queries.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• Optimized the embedded application T-SQL code as well as the stored procedure used to feed reports for better latency performance.
• Implemented various integrity constraints and triggers for data integrity and SQL features like complex joins, sub-queries, ranking functions and applocks etc.
• Optimized several complex stored procedures and SQL queries using Execution Plans, SQL Profiler and Database Tuning Advisor (DTA).
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Developed complex mappings using SSIS to transform and load the data from various source systems like Oracle into the SQL 2005 Server target staging database.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations as well as database maintenance tasks like defragmentation, re-indexing, and recompiling stored procedures.
• Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population, maintenance, reorganization, security, and recovery of databases.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created application-specific Data Marts so that users can access personalized dashboards via SharePoint of information that is specific to their department and business unit.
• Created multiple reports such as linked reports, sub, drill through and drill down reports depending upon the client’s need.
• Managed several Reporting Servers and creating ad-hoc reports from OLTP and OLAP including its delivery using push and pull delivery methods.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Deployed SSRS reports to the reporting server and assisted in troubleshooting deployment problems.
• Optimized reports by optimizing the embedded queries, or optimized the stored procedures that generate them.
• Used PowerPivot to import customer orders from an excel file into SQL Server tables
• Used .Net to create Web services
• Created Service Layers using C# and WCF.
• Implemented HTTP protocol and SSL to secure the information between WCF Service and Client.
• Developed code to validate the user credentials for authenticating users to access the WCF service.

Environment: Microsoft SQL Server 2005/2008, Integration Services, Analysis Services, Reporting Services, Management Studio, BIDS, SharePoint (MOSS), Visual Studio 2010, TFS, WCF, .NET

Confidential, Greenville, Pennsylvania

Sr. SQL/ ETL Developer

Responsibilities:

• Created new and modified existing stored procedures for better performance and also for documentation.
• Designed and implemented OLTP database using Microsoft SQL Server 2005.
• Created objects such as: Stored Procedures, Triggers, User define functions, Indices, Views, and Index views. Created T-SQL batches and database scripts in support of front-end applications, web applications.
• Analyzed the historical data and extracted required data using both T-SQL and SSIS to support the management decisions.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.
• Performed several administrative tasks like security, mirroring as well as automation of scripts and packages.
• Created new SSIS packages and modified existing SSIS packages implementing auditing and error handling.
• Involved in scheduling packages through SQL Server Agent and setting up shared schedules.
• Prepared feasibility reports for MOLAP Cubes against relational ROLAP for the application.
• Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
• Convinced the Project Manager that Analysis Services MOLAP Warehouse was a better option based on facts in the reports including performance differences.
• Implemented the Final Warehouse on Analysis Services, built Key Performance Indicators and Calculated Members.
• Communicated with the team members on regular basis. The change requests had to be made for all the implementations.
• Handled the reporting server and was actively involved in creation of various types of complex reports
• Created several reports using SSRS like drill through reports, linked and sub reports.
• Involved in full life cycle of Reporting starting from the Authoring phase, the Management phase all the way to the Delivery phase
• Responsible for identifying and defining the Datasets for the report generation, writing the queries for the drill down reports, and identifying and adding the report parameters.

Environment: SQL Server 2005/2008, SSIS, SSAS, BIDS, Management Studio, Server Agent, Windows Server 2003

Confidential, Jersey City, New Jersey

SQL Developer

Responsibilities:

• Created the T-SQL script to generate all the tables and relationships based on the finalized ER-Diagram.
• Created Stored Procedures, Views, and User Defined Functions to facilitate the automation of data entry by a front end application.
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created database documentation for table and column dictionaries and other material.
• Created queries, stored procedures, functions and triggers.
• Wrote complex queries, stored procedures, UDFs, and optimized their performance for better database read operations.
• Responsible for the indexing and performance tuning of the queries.
• Analyzed physical data model for ETL mapping.
• Actively involved in the dimensional data modeling and story boarding ETL processes.
• Designed the ETL process using SQL Server 2000 DTS Packages in which the data sources include Oracle.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Created DTS packages for loading the data from various sources involving flat file and Oracle tables.
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like defragmentation, re-indexing, and recompiling.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans. Prepared feasibility reports for MOLAP Cubes against relational ROLAP for the application.
• Performed several administrative tasks like security, mirroring as well as automation of scripts and packages.
• Scheduled jobs like backups, restoring of databases using the SQL Server Job Agent.

Environment: Windows 2000 Server, Microsoft SQL 2000, Enterprise Manager, Query Analyzer, DTS, Erwin