SUMMARY

• Over 12 years of Experience in Database and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS),SQLServer Reporting Services (SSRS),and Data Transformation Services (DTS)
• Strong Techno - functional knowledge from diverse roles played throughout the career in Pharma, Healthcare, Financial, Technology
• Strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Expertise in End to End Master data management solution delivery, solution architecture, stakeholder management, roadmap and strategy definition
• Involved in designing T-SQLprogramming artifacts such as complex queries, stored procedures, triggers (DDL and DML), indexes, and user-defined functions.
• Strong debugging skills and the ability to solve complex problems
• Excellent analytical/Communication Skills, Team Play and very much result Oriented
• Experienced in developing Conceptual, logical models and physical database design for Online Transactional processing (OLTP) using ERwin knowledge with execute the project management plan and run the project
• Extensive experience in TuningSQLqueries& improving the performance of the Database
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
• Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users inSQLServer Reporting Services (SSRS)
• Experience in generating on-demand and scheduled reports for business analysis or management decision usingSQLServer Reporting Services

TECHNICAL SKILLS

Databases: SQL Server 2000, 2005 and 2008 R2 /2012, Oracle 8i/11gBI

Tools: SSIS and SSRS, PL/SQL, SQL Developer, TOAD

Script: Shell script, VB Script

OS: Windows 7 and Windows Server 2003/2008, Unix

PROFESSIONAL EXPERIENCE

Senior SQL Developer/Data Architect

Confidential, Philadelphia, PA

Responsibilities:

• Analyzed functional and non-functional categorized data elements fordataprofiling and mapping from source to targetdataenvironment.
• Involved withdataprofiling for multiple sources and answered complex business questions by providingdatato business users
• Used ER Studio and ERWIN tool for conceptual and logicaldatamodelling.
• Provided architecture and technical lead / development for Business Intelligence solution including design,architectand integration usingSQLServer.
• Responsible for the entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Played a dynamic role during the requirements gathering, analysing and designing of the database
• Created mapping documents, functions speciation's document and technical specification documents
• Created and maintained all other documents related to project for instance mapping documentation, work flow documentation and configuration documentation
• Designed and created different ETL packages using SSIS and transferred data from Oracle source, Mainframe to MS SQL server destination.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files intoSQLserver 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Used various Control Flow tasks in SSIS like For Each loop Containers, Sequence container etc and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.

Senior SQL Developer/Data Architect

Confidential, Virginia, VA

Responsibilities:

• Analyzed functional and non-functional categorized data elements for dataprofiling and mapping from source to target data environment.
• Involved withdataprofiling for multiple sources and answered complex business questions by providingdatato business users
• Used ER Studio and ERWIN tool for conceptual and logicaldatamodelling.
• Provided architecture and technical lead / development for Business Intelligence solution including design,architectand integration usingSQLServer.
• Responsible for the entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Played a dynamic role during the requirements gathering, analyzing and designing of the database
• Created mapping documents, functions speciation's document and technical specification documents
• Lead more than 10 database off shore team
• Upgraded databases from SQL Server 2000 to SQL Server 2008 R2.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages. Created automated stored procedures for day end operations using SQL Server agent and modified data driven subscriptions, fine-tuning subscription execution.
• Identified and worked with parameters for parameterized reports in SSRS 2005/2008 R2 and used SSIS import/ export wizard for performing the ETL operations.
• Designed architecture for generic File mover system, to move the files from FTP and vice versa for across all client
• Formatted the reports using the variables, expressions and created detailed reports for the customers to help them purchase by showing demographic information based on various parameters.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Performed database transfers and query tune-ups, integrity verification, data cleansing, analysis, interpretation and optimization of stored procedures for faster retrieval of data and improved server efficiency.

Senior SQL Developer/Data Architect

Responsibilities:

• Migrated cegedim CRM application to Veeva CRM Application
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also helped the front end application developers with their queries.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created automated stored procedures for day end operations using SQL Server agent and modified data driven subscriptions, fine-tuning subscription execution.
• Identified and worked with parameters for parameterized reports in SSRS 2005/2008 R2 and used SSIS import/ export wizard for performing the ETL operations.
• Created cross-tab, drill-down, drill-through and sub-report using RDL (Report Definition Language). Promoted RDLs to reporting service server and have written queries for the drill down reports. Generated performance based reports for the managers to show sales against various measures like time, area, and price-range.
• Formatted the reports using the variables, expressions and created detailed reports for the customers to help them purchase by showing demographic information based on various parameters.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Performed database transfers and query tune-ups, integrity verification, data cleansing, analysis, interpretation and optimization of stored procedures for faster retrieval of data and improved server efficiency.
• Worked on SSIS packages, import and export wizard for transferring data from heterogeneous database (csv, text files and excel files) to SQL Server

Architect

Confidential

Responsibilities:

• Identify Data attributes that will be part of the MDM solution
• Profile data from identified source system data extracts and highlight data quality issues
• Integrate Source data with trust metrics incorporating the results of data quality.
• For Ad-hoc data import, build Data transformation rules based on the identified data quality rules
• Consolidation of clean data from identified source systems into MDM
• Create canonical data model. Provide ongoing management of clean Golden copy of master data centrally in MDM
• Created mapping documents, functions speciation's document and technical specification documents
• Analyzed functional and non-functional categorizeddataelements fordataprofiling and mapping from source to targetdataenvironment.
• Involved withdataprofiling for multiple sources and answered complex business questions by providingdatato business users
• Used ER Studio and ERWIN tool for conceptual and logicaldatamodelling.

Module Lead

Confidential

Responsibilities:

• Worked as adeveloperin creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications.
• Extensively used T-SQLin constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Views using T-SQLin Development and Production environment forSQLServer 2008.
• Writing complex Stored Procedures to meet the business requirements.
• UsingSQLProfiler to estimate the Slow Running queries and performance tuning purpose.
• Wrote complexSQLQueries using multiple joins for creating Adhoc reports using Report builder based on the requirements.

Senior Analyst

Confidential

Responsibilities:

• Worked as adeveloperin creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications.
• Extensively used T-SQLin constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Views using T-SQLin Development and Production environment forSQLServer 2008.
• Writing complex Stored Procedures to meet the business requirements.
• UsingSQLProfiler to estimate the Slow Running queries and performance tuning purpose.
• Wrote complexSQLQueries using multiple joins for creating Adhoc reports using Report builder based on the requirements.

Software Engineer

Confidential

Responsibilities:

• Worked as adeveloperin creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQLcode andSQLjoins for applications.
• Extensively used T-SQLin constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Views using T-SQLin Development and Production environment forSQLServer 2008.
• Writing complex Stored Procedures to meet the business requirements.
• UsingSQLProfiler to estimate the Slow Running queries and performance tuning purpose.
• Wrote complexSQLQueries using multiple joins for creating Adhoc reports using Report builder based on the requirements.