SUMMARY

• 13+ years of IT experience on Database Design and Development on SQL server in OLTP, DSS and Data warehousing environments. 10 years of solid ETL experience using SQL Server SSIS/DTS in a high transaction and multi - server production environment.
• Expertise in database activities like Data Modeling, Database Design, Development, Database creation and Maintenance, Performance Monitoring and Tuning, Troubleshooting, Replication and Documentation.
• Understanding in installing, upgrade, troubleshooting Microsoft SQL Server 2 databases and configuration of their tools.
• Proficient in Extract Transform load (ETL) data using SQL Server Integration Services (SSIS), Import/Export, Bulk Copy Program (BCP), Bulk Insert, DTS Packages, and Ad-Hoc scripts from DB2, Oracle, SQL Server, SAP BW, Excel file, other databases and Flat File sources and load into various company Entities.
• Worked as ETL Architect to design data BI Warehouse, Data validation, data cleansing, data transformation as well as writing and scheduling complex SQL Server jobs.
• Work as Team Lead to create and asssgin Task through TFS to off shore team, review codes and SSIS packages.
• Experienced in Agile software development methodology, activly paritiated in SCRUM and also have experience in leading SCRUM occasionally.
• Proficiency in creating and scheduling QA release and Monthly and Adhoc Prod release with proper step and documents.
• Expertise in writing SSIS packages with Configuration, Custom Logging, Deployment, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables, Expressions, Procedure Error Handling and Data Error Handling, in SSIS.
• Experience in creating Index, Stored Procedures, Views, appropriate Functions, and Triggers for efficient data manipulation and consistency.
• Proficient knowledge in T-SQL queries DDL / DML, perform most of teh SQL.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS, SSIS Packages.
• Experienced in report generation using Crystal Reports and Excel spreadsheet.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Expertise in generating reports like Drill through and Drill down reports and also different type of Dundas Chart, Dundas Gauge and Dundas Map for Reporting Services, Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Strong ability in Scheduling and Deploying reports on Report manger
• Experience in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Good knowledge in creating different Backup strategies and Restore of databases and Disaster Recovery plans.
• Create Logins to databases and assign different Users to it and apply Roles and Permission according to business requirements.
• Knowledgeable in designing XML documents using DTD, XML Schemas, XSLT and XPath queries for its integration in database.
• Experience in designing Database Models using Microsoft Visio and Erwin.
• Excellent communication and inter-personal skills with ability to work as a team player or independent player and with Leadership Quality and ability to interact with clients.
• Ability to work in challenging and versatile environments and strive for excellence.

TECHNICAL SKILLS

Operating Systems: Windows 10, ME/NT/2000/XP/2003, UNIX 4.0

RDBMS: MS SQL Server 2012/2008/2005/2000 , Oracle 11g,10g, 8i,9i, MS Access

ETL Tools: SQL Server Intégration Services (SSIS), DTS (Data transformation services) and Import/Export Data, Bulk Insert, BCP

Database Tools: SQL Profiler, SQL Query Analyzer, Management Studio, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, TOAD, VMware, SAP BW 7.1

Development skills: Transact SQL (T-SQL), PL/SQL, VB

Languages: C, C++, XML, JAVA, COBOL, HTML, XML, VBScript, ADO.NET

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0/10.0 , MS Excel, Excel Reporting using SSIS and Dundas Reporting Services Dashboard Bundle

DB Modeling Tools: MS Visio, Erwin.

Version Control: Team Foundation Server(TFS), Team Foundation Version Control (TFVC), Visual Source Safe, Version Manager

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Server Architect/ETL Architect

Responsibilities:

• Worked on requirement requirements gathering, analyzing and designing from DB2 AS-400 database to SQL Server 2008. Designed dynamically packages to run in any environment
• Designing teh data warehouse (TYPE 1) and core Database for teh system using Snowflake Schema including tables, Views, Stored Procedures, Indexes.
• Designed and developed SSIS Package Model (template) to validate, extract, transform and load data from OLTP system (DB2 AS400, Gateway) STG, SPG (Staging Database) to Confidential (warehouse).
• Created SSIS Package Model for Historical Load and Incremental Load (Daily Updates) to feed teh data warehouse from different sources like AS400, Maximo7, Cognos, Gateway, Flat File, CSV Files, and Excel 2007 and Inter System-Systema.
• Designed SSIS packages were made to run hourly to make teh OLTP data to be in sync with teh data in warehouse.
• Designed configurations, logging/auditing, package error handling, data error logging, checkpoint, Custom Email Notifications in SSIS Package model.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, Pivot Transformation, Merge Joins and Sort in SSIS 2008.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used for Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Teh warehouse designed was useful in finance accounting, purchasing, sales data as teh business users had teh current data for their evaluation.
• Used T-SQL queries for data extraction. Applied various business logic to scrub/clean/validate /convert /allocate teh data using string manipulations, analytical functions, data conversion functions, CTE (Common Table Expression), user defined functions, stored procedures and ad-hoc queries using SSMS.
• Mainly responsible for teh maintenance of data ware all jobs packages are running without any interruption to users worldwide.
• Created/edited SQL job in SQL Agent in development and participated in production deployment and send Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2008.

Confidential

Responsibilities:

• Aligned Matrix historical and Incremental data which is in 445 Calendar to Confidential period Fiscal Calendar.
• Change SSIS packages, tables, store procedures, constraints and views effected by calendar move are tested and upload to production.
• Played active role in requirements gathering, analyzing and designing multiple databases for Actual cost and BI Extract.
• Create Model SSIS package standard, error handling, data error logging, Custom Email Notifications in SSIS Package for Stage, DIM, Fact and Master Etc.…
• Created SSIS Packages by using advance tools (me.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate).
• Used Erwin to create Confidential Warehouses, Create ETL Mapping documents and Unit Testing Models scripts for each different models package.
• Created SSIS packages to load data from SAP BW to TS and PS (Staging database) and Also load DIM and FCT Tables from stage tables for historical and Incremental loads.
• Created different Story’s, bugs in TFS and assigned different tasks to Off Shore team, Code reviewed their each task.
• Created and Scheduled SQL Server Job for to run every night to load data in Confidential Warehouse.
• Created and scheduled QA releases and Monthly and Adhoc Prod releases with proper step and documents.
• Created complex Cubes using DSV and Fact and Dimension tables also construct attributes relationship and hierarchy in cubes.
• Created Calculations columns in DSV and build Database Dimensions.
• Create Logins and provide different level of roles and permissions to users and developers.
• Enforced teh Business Rules to filtered bad data from system by using T-SQL Statement, and implemented various Constraints for Data Consistency.
• Actively participated in review meetings with Project Manager, Business Analysts and Finance users and to ensure dat teh development of projects meet business and system requirements for each monthly iteration.

Environment: MS SQL Server 2012, 2008 R2/2005/2000, T-SQL, SSIS, SSRS, SSAS, SSMS, Oracle 11g, Windows Server 2003, 2012, ER-Win, MS Excel, SQL Server Business Intelligent Development Studio, Team Server 2012, 2008, Team Foundation Version Control(TMVC), DB2 AS400, IBM Maximo 7, Inter System-Systema, SAP BW 7.0.

Confidential, NJ

Senior SQL Server BI Developer (ETL)

Responsibilities:

• Developed tables, indexes, constrains for SQL Server billing database.
• Created teh complex SSIS Packages to import data from flat files, Oracle 10G data into new SQL Server billing database.
• Worked on TOAD and Oracle 10g to develop tables, stored procedures, functions in oracle database.
• Design and develop SSIS packages using various transformations including derived columns, conditional splits & look Confidential etc.
• Passing different variables to SSIS packages like server name and input filename.
• Using ProClarity for browsing more data in cubes in OLAP environment.
• Apply different complex business logic for FRT & Small package data, and wrote different store procedures views, functions and complex scripts for each process.
• Created SSIS packages to migrate data from .csv to MS SQL 2005/2008 and tan created text files dynamically to log errors for dat package.
• For big client’s design and developed Fact and Dimension tables in SSAS.
• Developed SSIS packages for importing data into Fact and Dimension tables.
• Generated drill down and drill through reports from OLAP cubes using SSRS.
• Created different MDX queries for browse data and reports development.
• For small client’s reports, me wrote complex scripts which pull data from back end using SQL pass through query in VBA in MS Access.
• Responsible for creating backups and distribute updated version of database to developers.
• Created and scheduled different jobs to run on daily and weekly basis for maintenance of database.
• Created documents for store procedure for import, export and other process in tool and also created data diagram and data dictionary for billing database.
• Responsible for maintaining Development and UAT environment and Production.

Environment: MS SQL Server 2000/2005/2008 , Oracle 10G, ProClarity, SSRS, SSIS, VB.Net, SSAS, Management studio, Version Manager (8.1), Toad, VM Ware, Windows XP, MS Visio.

Confidential, MA

Senior SQL Server BI Developer

Responsibilities:

• Enhanced teh old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data from MS SQL 2000 to MS SQL 2005.
• Responsible for maintaining Production, Development and UAT environment.
• Participated in testing disaster recovery model for PR system.
• Responsible for teh inception and implementation of Database Policy in teh organization.
• Perform T-SQL tuning and optimizing queries using Profiles and created new indexes for performance.
• Converting all existing DTS packages to SSIS packages.
• Reconciled data for transformation from MS SQL 2000 to SQL 2005 using SSIS.
• Responsible for creating batches & scripts for implementing logical design to T-SQL.
• Responsible for creating database objects (table, views, store procedure, triggers etc.) to provide structure to store data and to maintain database efficiently.
• Developed complex stored procedure using T-SQL to generate reports using Crystal Reports.

Environment: MS SQL Server 2005/2000, SSIS, XML, Crystal Reports 9.0, Windows 2000, Visual Source Safe.

Confidential, VA

SQL Server Migration Developer

Responsibilities:

• Played a dynamic role during teh requirements gathering, analyzing and designing of teh legacy database.
• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
• Converting all existing DTS packages to SSIS packages by adding extra task.
• Create design for facts and dimensional tables also developed data source view.
• Create different types of backups on daily and weekly basis and restore them whenever it requires.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data from SQL 2000, and MS Excel Sheet to load data in fact and dimension tables.
• Created SSIS package using different task like Foreach Loop Container and multicasting to migrate data from flat files and excel files.
• Run manually SSIS package fresh data on weekly basis for third party software for (Oracle 10g) and (SQL Server 2000).
• Created trace for optimizing queries using SQL profiler.
• Wrote complex store procedure and SQL Queries to perform data validation to make sure test results matched back to migrated data.
• Created drill through and drill down reports for sales flash and employee’s profitability reports.
• Troubleshooting teh reports for cents and colors issues in different reports.
• Responsible for creating database objects, tables, views, trigger indexes and define constraints to provide structure to store data and to maintain database.
• Created documents for scripts used to developed report and for migration of data.

Environment: MS SQL Server 2000/2005, Oracle 10g, SSIS, ProClarity, SSRS, Management studio, Windows 2000, MS Visio, Asp.net

Confidential, NJ

SQL Server BI Developer

Responsibilities:

• Played a dynamic role during teh requirements gathering, analyzing and designing of teh legacy database.
• Developed teh SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005.
• Scrubbing teh improper format data in staging area and drop and recreated index to migrate data faster.
• Run SSIS package daily basis for third party software.
• Wrote complex SQL Queries to perform data validation to make sure test results matched back to migrated data.
• Created batches & scripts for implementing logical design to T-SQL.
• Responsible for creating database, tables, views and define constraints to provide structure to store data and to maintain database efficiently for KPI database.
• Developed complex stored procedure and Views using T-SQL to generate reports using Crystal Reports 10.0.
• Deployed reports to report manager and troubleshooting for any error occur in execution.
• Schedule execution of reports in report manager and send them to managers on daily and weekly basis.
• Created matrix and drill down reports for sales profit, and Forecast reports.
• Created trace for optimizing queries using SQL profiler and database engine tuning advisor.
• Provided payroll and employee data in excel and CSV files to client for teh particular records they requested.
• Actively involved in Troubleshooting database performance issues.
• Created documents for scripts used to developed report and for migration of data.

Environment: Microsoft SQL Server 2000/2005, SSRS, Management studio, Windows 2000, SQL Server Integration Services (SSIS), MS Visio, Asp.net

Confidential, VA

SQL Server Developer

Responsibilities:

• Played a dynamic role during teh requirements gathering, analyzing and designing of teh Reports.
• Developed Data modeling organizing teh data and provide proper structure to database by implementing constraints to tables.
• Views and Index Views are created to reduce database complexities for teh Reports.
• Create Complex Store Procedure and scripts using T-SQL for reports.
• Create different types of backups for reporting database on daily and weekly basis and also restore them.
• Scheduled teh Reports to run on daily and weekly basis in Report tool and also email them to director and analysts to review in Excel Sheet.
• Developed different Scripts for teh Data analysts for Verification of reports.
• Enhanced teh old Excel Reports to new Crystal Reports fit new business requirement, and implemented into SQL Server.
• Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2000.
• Created DTS package are scheduled for migration old system data to new system and verify by making different reports on new system.

Environment: MS SQL Server 2000, Crystal Report 8.0, Management studio, DTS, Windows 2000, Erwin, MS excel 2003