SUMMARY

• 9 years of Extensive experience in the Architecture, Design, Development, Implementation and Support of complex Data engineering solutions for building Enterprise Data warehouses, Data Marts and Business Intelligence needs.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration and Metadata Management Services and Configuration Management.
• Strong experience in data research, analysis to build ETL solutions for Business Analytics.
• Experience in evaluating the technical feasibility and proposing the best suitable ETL and BI tools.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Architecture, Analysis, Design, Development and Implementation.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Extensive experience in visualizing the design of the system by UML, Class diagrams, ER Diagrams and web page mock - ups.
• Good knowledge on logical, physical, and dimensional data modeling, data mapping, and data normalization.
• Experience on converting large data sets from several legacy systems into one integrated target system
• Proficiency in creating different types of SSRS reports such as Matrix, Conditional, Drill-Down, Top N, Summary and Sub reports.
• Hands on experience in Logical and Physical Database design & development, ORDBMS Concept, Normalization and Data modeling using Erwin data model.
• Good Expose on usage of different RDBMS like MS-SQL Server, Oracle and MYSQL.
• In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, Reporting and Analytics.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing in SQL Server 2005/ 2008 R2.
• Led design, development, implementation of SSRS reports, and also management of the Microsoft BI reporting environment.
• Proficient in Dimensional modeling (star and snowflake schemas) and Relational database management systems.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2 and MS Access.
• Experienced in Developing, Deploying, Scheduling the ETL packages in the Production and UAT environments.
• Proficient in identifying the performance bottlenecks in Stored Procedure and SSIS packages as well as to troubleshoot a data/logical bug.
• Have extensive experience in building BI Products and Solution frameworks through Meta Data driven approaches.
• Experienced in performance tuning and optimizing for SQL server application by using performance monitor.
• Experience in package logging, error logging and event handling to redirect Errors rows and fix the errors in SSIS.
• Experience in creating Windows application using C#.net and WPF.
• Performance Tuning Databases using Execution Plan, Query Tuning Advisor and ETL.
• Hands on experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Proficient in maintaining the different code versions using SVN.
• Experience in supporting Very Large Databases up to a size of 2TB.
• Experience in Subscribing to Microsoft Sql Azure, Creating database in Azure, Setting up Sql Azure firewall, Service Bus.
• Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, Conformed Facts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.Working knowledge on Progress Database.
• MS CRM implementation, Customization, Development.
• Dynamic CRM installation, customization, advanced customization using Dynamic CRM SDK, MS Sql server development, administration, MS Sharepoint customization.
• Trained and mentored junior resources on SSIS, SSRS, SQL Server Management Studio.
• Ability to adapt to new skills and technologies and dedicated to maintaining high quality standards.
• Possess strong Analytical, Problem Solving skills and flexible to work with new environments.
• Excellent team Player with very good communication and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: MS-SQL Server Integration Services, Data Stage 7.5.1Database MS-SQL Server, Oracle, DB2 & MySQL, Microsoft Azure Database.

Methodologies: Agile, Scrum, Rational Unified process, Waterfall

Data Modeling Tools: MS-Visio, UML, Erwin

BI Tools: MS-SSRS, Hyperion IR, SSAS, R, Tableau 8.2

Operating Systems: Windows 2000/XP/7/8, Windows Server 2003/2008, Linux, UNIX

Scheduling Tools: MS-SQL Agent, Control M, Data Stage Director

Project/Process Management: MPP, MS-Visual Source Safe, Version One, Tortoise SVN, TFS

Business Tools: MS Word, Excel, Power Point, Outlook

Programming: SQL Server 2005/2008/2012, HTML, C#.net,WPF, XML.

Internet Tools: IIS, FTP, TCP/IP, SFTP, WinSCP

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Sr. Data Analyst MSBI

Responsibilities:

• Participated actively in meetings with project manager for understanding the bank business.
• Responsible for analyzing the types of data issues such as Basic Data Integrity Issues and Complex Data Issues of the unique components of the public pension business using SQL scripts and Stored Procedures.
• Designed and developed SSIS Packages using different components.
• Data analysis and developing logic for data cleansing.
• Prepared the High and Low Level Process Flow design for ETL process using MS Visio.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Responsible for the quality deliverables.
• Done Data Extraction, Transformation and loading from different large data set sources into a common analytical data model
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions
• Responsible for writing T-SQL queries, Stored Procedures, and user defined Functions, Views, and Indexes.
• Creating Views for developing SSRS Reports on the Hub database.
• Participated actively in all phases of SDLC from development to deploying and maintaining SSIS Packages.
• Responsible for deploying SSIS projects to SSISDB in Sql Server 2014.
• Responsible in Creating, managing SQL Server AZURE Databases.
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Participated in Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio
• Used Cisco Tidal Services to schedule SSIS packages.
• Worked on project-based directives for client CRM environments.
• Worked closely with clients to understand CRM application enhancement needs.
• Participated in implementing Kimball’s lifecycle methodology for designing and implementing data warehouse.
• Deployed SSRS Report to Report server and added subscriptions for scheduling the reports.
• Responsible in debugging the issues in the scheduled jobs.
• Participated in team meetings for understanding project requirements and enhancements.
• Used data profiling tools and techniques to ensure data quality for data requirements.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Responsible in writing C#.net code for connecting SSRS Report Server and downloading reports from Report Server.
• Created a Windows application for Business users using C#.net for viewing member information and update the Information in Sql server using Windows application.
• Worked on writing HTML code and C#.net code in SSIS Script task to send email using SMTP server.

Environment: SQL Server 2014 (SSIS, SSRS), Microsoft Azure, MS Visio, T SQL, C#.net, Cisco Tidal.

Confidential, Sacramento, CA

Senior Software Developer

Responsibilities:

• Participated actively on Clients Calls, meetings with Project Manager to discuss and produce alternatives of problems.
• Worked with business analyst to gather information on requirements
• Responsible for implementing the ETL solutions using SQL Server Integration Services
• Designed and Developed SSIS Packages using Control flow task, Dataflow Task, Execute SQL Task, Derived column task, Merge Join Transformation in SSIS Designer.
• Analyze the requirement document on every requirement from client.
• Responsible for writing T-SQL queries, Stored Procedures, and user defined Functions, Indexes for Testing Discrepant Records.
• Performed troubleshooting of client CRM issues and maintained documentation of all reported issues.
• Tuning SQL queries based on Query Execution plan.
• Extract the customer data as outlined in the agreement with the newly-appended information to be delivered to the customer.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Data analysis and developing logic for data cleansing.
• Responsible to commit the code in SVN repository to backup the source code.
• Responsible in generating SSRS Summary Report for each service on the extract data.
• Responsible in connecting to Sql Server database in Azure and extract data.
• Involved in creating Ad-hoc and static reports using SSRS (SQL Server Reporting Services).
• As per client requirements generate the Extracts in the client requested format with pgp encryption.
• Defined the Primary Keys (PKs) and Foreign Keys (FKs) for the Entities, created dimensions’ model star and snowflake schemas using Kimball methodology and designed them using ERwin 7.2.
• Involved in QA for Testing and analysis of DB Extract with Mainframe Extract.
• Involved in the discussion with the on sight SMEs for the clarification.
• Reviewed the ETL packages and produced the review records.
• Analyzing & Trouble shooting the ETL issues/errors during the development, testing and Production phases.
• Involved in deploying and scheduling SSIS Packages using SQL Server Agent.
• Production support on the CMAS services.
• Involved in creating log files for SSIS packages
• Worked on SSIS Event handling mechanism to send out an email whenever Job fails with the error message in the email.
• Hand on experience on writing HTML code and C#.net code in SSIS Script task to send email using SMTP server.
• Responsible for debugging the error in the scheduled jobs.

Environment: SQL Server 2012 Enterprise Edition (SSIS, SSRS), Microsoft Azure, C#.Net, T SQL.

Confidential, Newtown Square, PA

Sr. Data Analyst MSBI

Responsibilities:

• Responsible for implementing the ETL solutions/T-SQL script to fulfill the customer request.
• Involved in analyzing the data in the database and generate required output as per requirements provided from client.
• Participating actively on Clients Calls, meetings with Project Manager to discuss and produce alternatives of problems.
• Worked with business analyst to gather information on requirements
• Documented Technical & Business User Requirements during requirements gathering sessions.
• Created entity process association matrices, functional decomposition diagrams and data flow diagrams from business requirements documents.
• Participated in the tasks of data migration from legacy to new database system
• Worked on Metadata exchange among various proprietary systems using XML
• Handled performance requirements for databases in OLTP and OLAP models.
• Developed Cleansing and data migration rules for the Integration Architecture (OLTP, ODS, DW)
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Used Crystal Reports to generate Ad-Hoc Reports
• Responsible for writing T-SQL queries and Stored Procedures.
• Developed, modified, and optimized complex queries to data retrieval and modification.
• Responsible for implementing the ETL solutions using SQL Server Integration Services
• Involved in creating SSRS Reports for some services based on the requirement.
• Involved in testing the data generated after applying business rules.
• Responsible in extracting data from Cloud services like Microsoft Azure.
• Responsible to debug the error and find solution when job fails in Production phase.
• Designed and Developed SSIS Packages using Control flow task, Dataflow Task, Execute SQL Task, Derived column task, Merge Join Transformation in SSIS Designer.
• Analyze the requirement document and prepare a Solution to extract the data as per requirements.
• Applied performance tuning techniques to the SSIS packages.
• As per client requirements generate the Extracts in the form of Fixed Width Flat Files.
• Responsible for the quality deliverables.
• Provide technical support for the team.
• Created simple reports for the end user delivery purpose.

Environment: SQL Server 2008 Enterprise Edition (SSIS, SSRS), TSQL, Visual Studio 2005/2008.

Confidential, Sacramento, CA

Senior Software Developer

Responsibilities:

• Participated actively on Clients Calls, meetings with Project Manager to discuss and produce alternatives of problems.
• Participated on Migrating the SQL scripts from the Corestore to Diablo database.
• Designed and Developed SSIS Packages using Control flow task, Dataflow Task, Execute SQL Task, Derived column task, Merge Join Transformation in SSIS Designer.
• Responsible for writing T-SQL queries, Stored Procedures, and user defined Functions, Indexes for Testing Discrepant Records.
• Responsible in taking Scripts backup for future reusability of code.
• Responsible in making additional changes proposed by client while migrating the script to Sql server environment.
• Participated in Designing and implementing Microsoft CRM Architecture.
• Worked on creating a solution using Kimball’s lifecycle methodology.
• Responsible to commit the code in SVN repository to backup the source code.
• Used package logging to log errors and finding the cause for errors.
• Involved in sending Emails from SSIS package in HTML format using script task when package execution failed with the event handling mechanism.
• Responsible in deploying SSIS packages, SSRS Reports after completing development and testing.
• Responsible in generating the Extracts on Corestore as well as Diablo databases.
• Involved in the discussion with the onsight SMEs for the clarification.
• Involved in QA for Testing and analysis of Diablo DB Extract with Corestore Extract.
• Fixing the issues based on the SMEs responses and delivered the extracts to client.

Environment: SQL Server 2012 Enterprise Edition (SSIS 2008 R2), TSQL

Confidential

Senior Software Developer

Responsibilities:

• Participated actively on Clients Calls, meetings with Project Manager to discuss and produce alternatives of problems.
• Understanding database mapping documents between mainframe and SQL and migrating the code.
• Involved in migrating services using Mainframe to Sql server.
• Responsible to commit the code in SVN repository to backup the source code.
• Responsible for implementing the ETL solutions using SQL Server Integration Services
• Designed and Developed SSIS Packages using Control flow task, Dataflow Task, Execute SQL Task, Derived column task, Merge Join Transformation in SSIS Designer.
• Responsible for moving package to production (Deploying SSIS package using SQL Agent).
• Responsible for regenerating extracts that are there in the Mainframe using SSIS.
• Responsible for writing T-SQL queries, Stored Procedures, and creating views, Indexes for Testing Discrepant Records.
• Responsible in understanding Kimball’s Methodology used to create destination data warehouse.
• Involved in different phases of testing the mainframe Extracts and Sql server Extracts.
• Involved in QA for Testing and analysis of DB Extract with Mainframe Extract.

Environment: SQL Server 2008 Enterprise Edition (SSIS 2008), TSQL.

Confidential

Software Developer

Responsibilities:

• Participated actively in Clients Calls, meetings with Project Manager to discuss and produce alternatives of problems.
• Worked with other teams who use the generated data from developed solutions.
• Perform data modeling, data source analysis, data sourcing specifications, ETL design & specification using kimball methodology.
• Responsible in making changes to the SSIS packages and SQL scripts as per other team requirements.
• Actively involved in managing the data in several databases.
• Developed, modified, and optimized complex queries and stored procedures to data retrieval and modification.
• Creating and maintaining test data.
• Creating and managing ETL Mapping specifications
• Involved in Data Cleansing using SSIS Derived Columns.
• Involved in Creation, Development and Deployment of SSIS packages.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Involved in the design and development of tables, queries, stored procedures, functions, etc. on SQL Server database
• Involved in fine-tuning SSIS packages, SQL queries, etc.
• Developed SSRS report.
• Involved in preparation of test cases, unit testing and bug fixing.
• Prepared the high level, technical design documents and deployment documents.

Environment: SQL Server 2008 Enterprise Edition (SSIS), TSQL, Visual Studio 2005/2008.

Confidential

Software Developer

Responsibilities:

• Developing various Data Stage Parallel jobs by using Data Stage Designer as per business scenarios like Validations, tedious reject processing as well naming standards.
• Gathering requirements and enhancements in already existing code and making changes as per requirements.
• Involved in testing the code and identifying issues in the code.
• Communicating client for issue resolutions/understanding the business requirements
• Responsible for Meta Data import/export and Parameterization and metadata lineage for the jobs as well bug fixing.
• Involved in all the stages of development life cycle from gathering requirements to implementing solution.
• Writing Test cases, executing & pasting results for the jobs.
• For the purpose of execution of test cases need to load test data into MS-Access

Environment: Data Stage 7.5.1 PX and SQL Server 2000