SUMMARY

• Over 11 years of strong experience in Information technology industry with 2 plus years of as Microsoft BI Lead\Architect.
• 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.
• Expert in developing reports in SQL Server 2005/2008/2008 R2/2010 Reporting Services (SSRS)/2012 and deploying them using web applications onto web servers.
• 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.
• 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.
• Experienced in Installation, Configuration, Maintenance and Administration of SQL Server 2008R 2/2008/2005/2000/7.0 in standalone and clustered environments.
• Experienced in migration of SQL Server from version 2000 to 2005/2008/2008 R2 And documented the Upgrade process.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot and Transactional with updatable subscriptions), Log shipping, Clustering (Active - Active and Active Passive) and Database Mirroring.
• 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.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Recovery procedure and involved in the migration and upgrade of databases.
• 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

• 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 BI Lead/Senior Developer

Responsibilities:

• 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
• Created a SSIS Packages to Load the Data from the Old data base to the New data base and also joined the Spreadsheet sheet 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.
• Produced 3NF data models for OLTP designs using data modeling -best practices- modeling skills.
• Logical Data Modeling & Process Modeling.
• 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.
• 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.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• 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.
• Created a Batch script to refresh the Excel spreadsheet with the sql query pointing to the concerned data base for the Gl Reconsilation.
• 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 York

Microsoft BI Lead/Architect

Responsibilities:

• Involved in gathering requirements, analysis, and specifications from the clients.
• 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.
• Logical Data Modeling & Process Modeling.
• 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.
• 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.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
• Modified or enhanced the stored procedures and views for performance issues.
• Used Local and Global Temporary tables in the stored procedures as per the requirement and better perfomance
• 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.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRSreports using the Global variables and expressions.
• Having regular calls with controllers for understanding the issues and providing them with clear resolution to the issues based on the tickets which they rise.
• 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), InformaticaCompany: Cloudeeva Inc

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 Dynamic SQL queries to load the data in to SSRS reports.
• Created a 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.
• Created an SQL services Jobs to load the daily data in to the SQL which the controllers enter their finance details.
• Having regular calls with controllers for understanding the issues and providing them with clear resolution to the issue.
• Performing monitory activities such as application performance etc.
• Installation, Configuration and Administration of SQL Server 2012
• 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 2012, T-SQL, SQL Server Integration Services (SSIS), SQL Server Report Services (SSRS), My SQL

Confidential, Hoffman Estates, IL

MS SQL Server/SSIS/SSRS/DBA

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.
• 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.
• Having regular calls with controllers for understanding the issues and providing them with clear resolution to the issue.
• Performing monitory activities such as application performance etc.
• Installation, Configuration and Administration of SQL Server 2008, 2005 and 2000.
• 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.
• 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, Aliso Viejo, CA

MS SQL Server Developer/BI

Responsibilities:

• Actively involved in the design of the database schema.
• Designed tables, indexes and constraints to maintain data integrity and also ensured efficiency in data retrieval/manipulation.
• Worked on migration of SQL Server 2005 instances to SQL Server 2008.
• Installed all software upgrades for SQL Server 2008.
• Developed complex stored procedures to efficiently retrieve/manipulate data as per requirement.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Files at runtime. Used check points, break points and event handlers while running packages.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS.
• Wrote MDX expressions to create name sets, calculate members and KPIs.
• Planned the complete back-up of various databases for disaster recovery scenarios.

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

Confidential, Lisle, IL

MS SQL Server/DTS/SSAS Developer

Responsibilities:

• Researched database issues (specifically performance issues).
• Created and monitored all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Created, modified and monitored replication on all databases.
• Installed all software upgrades for SQL Server.
• Modified theexisting stored procedures, views and triggers to meet the current design.
• Used DTS packages to populate data from various data sources.
• Involved in creatingDTSpackages to integrate the data coming from various data sources.
• Have configured and maintained report manager and report server for Cristal Reports.

Environment: MS SQL Server 2000, T-SQL, Data Transformation Services (DTS), Crystal Reports.

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.

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications of the system.
• Created reports on purchases charged to grants, contracts, sponsored programs, restricted funds by specific expenditure policy of the funding source
• Tested to optimize the procedures and triggers to be used in production.
• Extensively involved in creating Standard, Cross-tab, Drill Down, and Sub Reports (linked, unlinked and on-demand) using Crystal Reports 10.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Involved in scheduling the monthly and Weekly Reports.

Environment: MS SQL Server 2000, Crystal Reports 10, Crystal Enterprise, CMC, DTS, CMC, and T-SQ