SUMMARY:

• Over 10 years of strong experience in Information technology industry with 6 plus years of DW/BI efforts as Microsoft ETL Developer\Reports Developer\BI efforts from requirement gathering to its implementation.
• Experienced in covering all stages of development life cycle including business process analysis, requirements gathering and analysis, high level design, detailed design, development, testing, QA and post implementation support, SQL Server Architecture, Database Administration, Installation/ Configuration, Data Centre Management, Troubleshooting and Disaster Recovery.
• Very good knowledge of Data Warehouse/Data mart concepts and Expertise indata modeling for OLAP & OLTP systemsfrom design and analysis to implementation includingthe conceptual, logical and physical data models.
• Supported team in resolving SQL Reporting services and T - SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional,Drill-down,Top N, Summary, Form,OLAP and Sub reports, and formatting them.
• A direct Client Interaction catalyzed my problem identification capability and troubleshooting techniques have accentuating the approach for resolution.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008/2005, Import/Export data, Bulk insert and BCP.
• Created Reports from Web Services and used MDX on Cubes in SSAS to create reports in SSRS
• Modified SSRS/SSIS config files which is written in ASP.net XML scripting.
• Exported SSRS reports to Excel, word document and Pdf for the Business to do the analysis on that.
• Expert in SSIS script transformations and scheduling complex SSIS Packages for transferring data automatically from multiple data sources to SQL server.
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting.
• Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Highly skilled working as an individual as well in a team. Great ability to work on multiple projects at the same time, setting up priorities and delivering the requests before deadlines.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills

TECHNICAL SKILLS:

Skills: MS SQL Server 2000/2005/2008/2012/2014, SQL Server Integration Services(SSIS)/SQL Server Analysis Services(SSAS)/SQL Server Reporting Services(SSRS), Informatica, Windows NT, Windows, XP/ 2003/2000/98, UNIX, Erwin 7.0, MS VISIO, MS SQL, Profiler, SQL Query Analyzer, SQL,PL/SQL,C,C++,C#,VB, MS ACCESS,MS Office 97/2003/2007, Quality Center, Load Runner, Facets 4.51,IBM DB2, Tableau, Qlickview

PROFESSIONAL EXPERIENCE:

Confidential, Jersey city, New Jersey

Microsoft Lead\Senior BI Developer

Responsibilities:

• Create various file and database validation rules like schema validation, null file validation, invalid file format validation, duplicate file validation and database connection check validation.
• Create\document ETL framework and a template package to help developers understand ETL development strategies.
• Involved in the designing process of the data ware house with the requirements from the business.
• Had a daily Scrum meeting with team to discuss on the challenges on the design and the development of this DW process
• Coordinate with manila development team, assign them tasks and help with any technical queries.
• Created a SSIS Packages to Load the Data from the Old data base to the new data base and also joined the Spreadsheet loads to the same package for the DW.
• Created 16 Store procedures with the logics to enhance the data from the old DB to New FRD DB
• Created few Reporting Views for the business to pull the data for their analysis.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Created an SQL services Jobs to load the daily data in to the SQL which the controllers enter their finance details.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
• Deployed the reports to the sql server and file source.
• Experienced in deploying the reports to one server to another server by using parameters in ssis.
• Used Sql Profiler for troubleshooting, monitoring, optimization of SQL server 2008 and SQL code.
• Prepared the complete data mapping and Report Definitionsfor the project which involved around 33 reports.
• Expert in creating SSRS Reports and exporting them to the Excel sheets for the business to do the analyis
• Created a Batch script to refresh the Excel spreadsheet with the Sql query pointing to the concerned data base for the Gl Reconciliation.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Closely working with the testing team and solving the issues which came from the UNIT Testing.
• Involved in creating Data marts according to the each client data using SSAS.

Environment: MS SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Report Services (SSRS), Server Analysis Services (SSAS)

Confidential, Jersey City, New Jersey

Microsoft BI Developer

Responsibilities:

• Interacted with Development Teams and Managers to analyze business needs. Provided software product design and developed a technical roadmap for the solution through the project lifecycle and Confidential
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables
• Involved in KT sessions and different Controllers meeting to understand the Business.
• Design and development of automated ETL processes to load DW using SSIS from Access and Excel Source to Sql Server Data base.
• Created SSIS packages based on the requirements to load the Excel files of different sheets by the naming conversion of the files to load into different tables in SQL server by using Script task.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Produced 3NF data models for OLTP designs using data modeling -best practices- modeling skills.
• Created DynamicSSISpackages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures andSSIS packages.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy and Exact lookups and String manipulations.
• Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency.
• Performed ETL usingSSISby extracting data from various data sources such as MS Access, Excel, Flat files, CVS files and network locations
• Used variousSSIStasks such as Conditional Split, Derived Column, and Lookup which were used for data scrubbing, data validation checks before loading the data into the Data Warehouse.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Created different solutions and loaded the data as per the management requirements.
• Created an SQL services Jobs to load the daily data in to the SQL which the controllers enter their finance details.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS transformations.
• Performing monitory activities such as application performance etc.
• Involved in creating Data marts according to the each client data using SSAS.

Environment: MS SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Report Services (SSRS), Server Analysis Services (SSAS), Informatica

Confidential, San Jose, CA

MS SQL Server/SSIS/SSRS Lead

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from other teams and passed it to the offshore team.
• Involved in KT sessions and different other team meeting to understand the Business of each team in Confidential .
• Design and development of automated ETL processes to load DW using SSIS.
• Created SSIS packages based on the requirement from the managers to transform data into Microsoft SQL from My sql to Sql server 2012.
• Created different solutions and loaded the data as per the management requirements.
• Developed different kind of reports as per the requirements from each team.
• Created a ASP.net web link for deploying the SSRS Reports to that link for the business to view in the internet portal link
• Created a Dynamic SQL queries to load the data in to SSRS reports.
• Created stored procedures to load the larger data in to excel files by using the BCP Command.
• Created a Stored procedure for the XML Scripting to have the count of Volumes in tabular format.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS)
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Created an SQL services Jobs to load the daily data in to the SQL which the controllers enter their finance details.
• Created an Access DB to get the details for the North America Savory controllers to gather the details for their business purpose.
• Created an excel pivot files for comparing the records from Access and SQl to check the data loaded in the Access is same vales in SQL (Automated process)

Environment: MS SQL Server 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Report Services (SSRS), My SQL

Confidential, Hoffman Estates, IL

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from the finance team
• Involved in KT sessions and different Controllers meeting to understand the Business of Sensient.
• Design and development of automated ETL processes to load DW using SSIS.
• Created SSIS packages based on the requirement from the managers to transform data into Microsoft SQL from different access process optimized the links between tables or to match fuzzy data from different database.
• Created different solutions and loaded the data as per the management requirements.
• Developed 23 SSRS Reports for the controllers and to the Higher Management.
• Involved in writing MDX Scripts for the OLAP CUBES
• Created different reports and exported automatically to the excel files and send a automatically through email by using report manager configuration..
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Created a Dynamic SQL queries to load the data in to SSRS reports.
• Created an SQL services Jobs to load the daily data in to the SQL which the controllers enter their finance details.
• Created dynamic T-SQL queries with complex logic to search for the needed purchases, sales and services information.
• Created an Access DB to get the details for the North America Savory controllers to gather the details for their business purpose.
• Created an excel pivot files for comparing the records from Access and SQl to check the data loaded in the Access is same vales in SQL(Automated process)

Environment: MS SQL Server 2008/2008R2/2012, T-SQL, SQL Server Integration Services (SSIS),SQL Server Report Services (SSRS), My SQL

Confidential, Northbrook, IL

MS SQL Server/SSIS/SSRS/SSAS Developer/DBA

Responsibilities:

• Calculated sales amount, purchase amount, revenue and expense for each warehouse, area service manager, and field engineer or service ticket record.
• Communicated with the management group and figured out the correct calculation in multiple reports and warehouse dimensions.
• Created dynamic T-SQL queries with complex logic to search for the needed purchases, sales and services information.
• Cleaned the table content by comparing the company records (in excel or SSRS) from other department and data collected from recent database with T-SQL query.
• Create SQL Server Agent jobs to schedule the database updating and problem detecting.
• Optimized the design of data warehouse by using SQL Server Profiler against the updating process of data warehouse.
• Provide RCA for new issues that we come across by analyzing the available data.
• Identified the cause of recurring issue and fix it, if the issue cannot be fixed by our team then escalate it to the respective team
• Having regular calls with onshore team and clients for understanding the issues and providing them with clear resolution to the issue.
• Created SSIS packages based on the requirement from the managers to create Excel reports or to optimized the links between tables or to match fuzzy data from different database.
• Compared the historical reports in BIDS SSRS with the new generated report in Tableau.
• Installation, Configuration and Administration of SQL Server 2008, 2005 and 2000.
• Checking the status of Backup troubleshooting the failed backups and Restoration of Databases.
• Established Disaster Recovery & Business Continuance Plans

Environment: MS SQL Server 2008/2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Report Services (SSRS), MySql.

Confidential, Chicago, IL

Responsibilities:

• BMC Remedy tool Incident management and resolution.
• Developed custom reports, tools to save manual efforts & time. Coordinate with onshore team regarding Enhancements & Deployments in AFS and Operational Support.
• Worked on creation and modification of stored procedures in SQL to satisfy client requirements which is used as lookup in the front end of the Invoice processing tool of AFS.
• Deployed processes for new instances and implement new changes for the existing applications.
• Responsible for working with teams, vendors and other business partners and make sure that all areas of the release are properly managed.
• Provide RCA for new issues that we come across by analyzing the available data.
• Identified the cause of recurring issue and fix it, if the issue cannot be fixed by our team then escalate it to the respective team
• Having regular calls with onshore team and clients for understanding the issues and providing them with clear resolution to the issue.
• Modified and created DTS packages and changed the config settings which is written in asp.net
• Created a application in Asp.net and configured through IIS to publish in the www root portal.
• Performing monitory activities such as application performance etc.
• Installation, Configuration and Administration of SQL Server 2008, 2005 and 2000.
• Hands on experience on troubleshooting TEMPDB issues and database issues.
• Developing the successful Backup strategies based on Recovery models.
• Recovery of Database at the time of Database crashes or data loss.
• Checking the status of Backup troubleshooting the failed backups and Restoration of Databases.
• Established Disaster Recovery & Business Continuance Plans

Environment: MS SQL Server 2008/2008R2/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Report Services (SSRS), My SQL

Confidential

MS SQL Server / DTS / SSRS Developer

Responsibilities:

• Calculated sales amount, purchase amount, revenue and expense for each warehouse, area service manager and field engineer or service ticket record.
• Communicated with the management group and figured out the correct calculation in multiple reports and warehouse dimensions.
• Created dynamic T-SQL queries with complex logic to search for the needed purchases, sales and services information.
• Create SQL Server Agent jobs to schedule the database updating and problem detecting.
• Optimized the design of data warehouse by using SQL Server Profiler against the updating process of data warehouse.
• Created SSIS packages based on the requirement from the managers to create Excel reports or to optimized the links between tables or to match fuzzy data from different database.
• Involved in the development of MySQL environment including creating combined tables, views, stored procedures and indexes.

Environment: MS SQL Server 2008/2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Report Services (SSRS), MySQL.