SUMMARY

• 10 years of experience in IT as MS SQL Server 2008/2005/2000 Database Developer in Windows Environment.
• 5 years of extensive experience in T - SQL, Informatica 8.x version, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).
• Experienced working in Data modeling using MS Visio, MDM (Master data management), DQS (Data Quality Services).
• Experienced in Design, Development, Testing, Implementation and Production, support SDLC of Data Warehouse, RDBMS and Web Based Application.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from heterogeneous/homogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
• Extensive knowledge in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• In-depth knowledge of Transact-SQL and PL/SQL (DDL and DML).
• Experience in optimizing the database by creating various Clustered, Non-clustered indexes.
• Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Good knowledge in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Experience in designing Database Models using MS Visio.
• Knowledgeable in planning and implementing MS SQL Server Security and database Permissions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Technologies: MSBI (SSIS, SSRS, SSAS) Informatica 8.2

Database: MS-SQL Server 2012,2008,2005

Programming Language: ASP, ASP.NET, C#, Jscript, Confidential Navision

Project Planning: MS Project, Excel

Version Control: Team Foundation, Team Forge, Clear Case, SVN, VSS

Other Tools: MS Visio, PPT

PROFESSIONAL EXPERIENCE

Confidential, OH

ETL Architect

Responsibilities:

• Working for data migration project with MSBI - SSIS tool.
• Project involves migrating data from old system to new SQL Server database 2012
• End to end project execution right from requirements gathering, functional specification, technical specification, project planning, development, QA planning, team management and implementation in production and warranty support.
• Cubes creation for data analysis and reports for data quality and KPI measurements. MDX queries for complex analytics reporting
• Master Data Management for all the policy and membership data using SQL 2012 MDS services feasibility and architecture blue print
• Created logical and physical data model for SQL Server 2012
• Create dashboard for executive level summary details of the analyzed data
• Support existing SSIS packages and reviewing existing architectural issues and working on work around and fixing the issues
• Database logical model review and performance tuning of stored procedure, views and other SQL objects
• Managing onsite and offshore team with business and technical guidance and directions
• Creating tools and automation of tasks.

Environment: s - SQL Server 2012, 2008, SSIS, SSAS & SSRS

Confidential, Atlanta, GA

ETL Architect

Responsibilities:

• Credit card payment interface project which helps small merchants to process the payments with VISA, Master Card, AMEX, Discover cards to enhance their business.
• MDM service for all onboarding merchants’ data using IBM Initiate tool for minimizing errors in equipment shipment and gateway setup.
• Merchants are on boarded to the system in two ways thru UI and batch processing.
• SSIS packages were created for on boarding the merchants and process their payments
• Complex Stored procedures created for UI related task or activity for completing the onboarding process.
• Logical data model design and review for optimal performance of the system
• SSAS cubes created for measuring stats of the merchants and providing reports on monthly basis like frequency of the transactions and trend analysis.
• SSRS reports created for delivering scheduled reports.
• Managing onsite and offshore team with business and technical guidance and directions
• Queue monitoring dashboard automation on real time status.
• Application support meeting the SLAs.

Environment: s - SQL Server 2008, SSIS, SSAS & SSRS, IBM Initiate Tool

Confidential, San Francisco, CA

Sr Technical Consultant

Responsibilities:

• Short engagement to create data quality metrics for the existing bank data and process enhancement
• Primary duty is to study the design of the packages and cubes and their impact on data quality
• Architecture review of the packages and cubes, providing best practices.
• Complex T-SQL created for collecting the data metrics and data quality analysis done in excel spreadsheet as quick and easy dashboard solution
• MDM feasibility analysis and estimation

Environment: s - SQL Server 2008, SSIS, SSAS & SSRS

Confidential,, Chicago, IL

Sr Technical Consultant

Responsibilities:

• Short engagement to automate various stages in business process by integrating SSIS packages created for processing the data from various banks for credit analysis
• Different financial institution sends data at different point in time for credit data processing.
• Understanding the design flaw in the integration process across multiple stages in the business flow
• Complex stored procedure fine tuning and performance enhancement
• Created OLAP cubes and reports for executive level summary dashboard and MDX queries

Environment: s - SQL Server 2008, SSIS, SSAS & SSRS

Confidential, Louisville, KY

ETL Architect

Responsibilities:

• Enterprise wide Data warehousing initiate to collate all the data in a central repository and providing real time data availability for interfacing apps
• Responsible for creating common interface gateway for integrating acquired organization data for efficient operation of business
• Architecture and planning with multiple teams understanding upstream and downstream dependencies and minimal impact to issues with business
• Data quality reporting with COTs and custom build tools to ensure no data loss and data corruption critical for effective business delivery.
• Created Informatica workflows for mainframe source systems and SSIS packages for TXT,CSV and RDMS data sources
• Created complex stored procedures for data manipulation for real time systems.
• MDM of existing groups and members’ data and acquired company data. This minimized the privacy issue and adheres to compliance of the member data.
• SSAS cubes for reporting executive summary level dashboard using SSRS and OBIEE and MDX queries
• Project execution and people management consisting of 30 member team.

Environment: s - SQL Server 2008, SSIS, SSAS & SSRS, Informatica 8.2,IBM Initiate Tool

Confidential, Seattle, WA

Technical Analyst

Responsibilities:

• This project was responsible for delivering warranties and claims for all Confidential aircrafts owned or leased by airline companies across the globe
• Solution analyst for analyzing the requirements from business and laying technical fine print for accomplishing the tasks
• Responsible for designing ETL solution using SSIS for processing the data from different airline customer from different regions of the globe
• Developed and deployed 20 - 25 packages and SSAS cubes for summary level dashboard
• Data quality dashboard and delivered scheduled reports using SSRS reporting
• Project planning and execution, maintained team of 10 members including developers and testers

Environment: s - SQL Server 2008, SSIS, SSAS & SSRS

Confidential, Dallas, TX

Technical Analyst

Responsibilities:

• Client wanted to calculate Direct and Indirect spend associated with the organization with was manufacturing company making small aircrafts, helicopters and golf carts etc
• Primary responsibility was to design a system which will acquire all the data across different platforms in the organization. Process the data to required format.
• Design EDW with multiple stages to transform the data using SSIS packages
• Custom data quality tool automation for error reporting and measuring data standards
• SSAS cube creation for dashboard and end reporting tool was business objects for drilling down the data to granular level and MDX queries.
• Pre-data processing and Post-data processing validations automation for enforcing data quality
• SQL Server 2005 performance tuning of the stored procedures
• Project planning and execution.

Environment: s - SQL Server 2008, SSIS, SSAS & SSRS

Confidential, Redmond, WA

Technical Analyst

Responsibilities:

• The project involves configuring of Performance Point Server Batch framework for execution and monitoring of sql jobs to support the forecast cycle of financial users across the globe.
• Confidential office across the globe report their earnings which is manipulated by mathematical model to calculate the revenue for the quarter or for the year
• Complex stored procedures are designed for mathematical model manipulation of forecast data figure
• Automation of PPS gateway process for providing access and privilege to business users for entering the data.

Confidential, Redmond, WA

Senior Software Engineer

Responsibilities:

• This project rolls out learning and readiness program for all the Confidential employees across the globe enabling them to know about the new products and service in their area.
• Heavy SQL server project involving batch processing with complex stored procedure design.
• Responsible for requirements gathering, functional specification, technical specification, project planning, development, QA planning, team management and implementation in production and warranty support.
• Involved in Database design and development for SQL Server 2005 database objects including tables, views, complex stored procedures and DTS packages
• Work in creating the test scenarios and test case for QA execution and sign off. Involved in integration of the feed with upstream and downstream system dependencies.
• Worked as project manager executing the project with project planning and execution with a team of 30 members.

Confidential

Senior Software Engineer

Responsibilities:

• This project was about understanding Treasury operation for drafting the application and supporting the system
• Application consisted of in-house ASP application, SQL Server database and third party application - Sungard Tracker
• Analyzed complex stored procedure for design flaw and fined the procedures for performance tuning.
• Internal Infosys certification of liquidity, debt and investment management