SUMMARY

• About 9+ of experience in IT, as MS SQL Server 2008/2005/2000 Database Developer with strong background in Data warehousing and ETL experience.
• Extensive experience in Information Technology with special emphasis on design & development of Database/Data Warehousing applications and Software Development Lifecycle (SDLC).
• Expert in designing and implementing Database using various RDMSs like SQL SERVER, Oracle and MS Access, DB2.
• In - depth knowledge in various RDBMS concepts like Database, Tables, Table Normalization, User Defined Data Types, Views, Indexes, Stored Procedures, User Defined Functions, Triggers, CTE(Common Table Expression) etc.
• Proficient in working with Transact-SQL DDL and DML.
• Excellent knowledge in ETL (Extract - Transform - Load) using SQL Server Integration Services 2008/2005 (SSIS), DTS, Bulk Insert.
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Expert in Data Migration. Formulated data from legacy systems. Established cleansing, Mapping and enrichment.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience in designing and developing reports on SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) and OLAP (Creating cubes).
• Worked on Report Manager to Subscribe Reports, Assign roles, user access with respect to security.
• Excellent knowledge in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Knowledge of Scheduling and Deploying reports on Report manger.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.
• Expert in Creating Deployment packages for SQL Server Database, Reports and SSAS Database using command line.
• Good proficiency in SSAS cubes development and processing including Dimensions and measures design.
• Participated in design of Staging Databases and Data Warehouse/Data mart using Star Schema/Snowflakes schema in data modeling.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked very closely with Project Manager to understand the requirement of reporting solutions to be built
• Developed C#.NET scripts for SSIS packages.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduling DTS and SSIS Packages.
• In-depth knowledge in Tuning SQL Queries and improving query performance.
• Worked extensively on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

TECHNICAL SKILLS

Programming Languages: Visual Basic 6.0, C, C++, Core JAVA, C#.net, SQL/PL-SQL, T-SQL, HTML, XML.

RDMS and Database Tools & Technology: MS SQL Server 2000/2005/2008 , Oracle 9i/10g, MS-Access, Query Analyzer, Management Studio, SQL Server Business Intelligence Development Studio, DB2.

Operating Systems: UNIX, MS DOS, Windows 95/98/NT/2000/XP/Vista/7

Utility & Tools: Microsoft Visual Studio2008 R2, TFS, SubVersion, SQL Profiler, MS Office/Outlook Express

PROFESSIONAL EXPERIENCE

Confidential

TECH LEAD \SQL SERVER\BI Developer

Responsibilities:

• Lead the team of 6 people at offshore.
• Conducted one-on-one sessions with business users to gather data warehouse requirements
• Worked with BAs to understand SAP system and Migration requirement.
• Daily Job include Management meeting, interaction with Business User as well as Offshore Coordination
• Design/Develop Plans to implement new changes to System.
• Working on Data Migration Legacy to SAP system which includes designing new SSIS Packages, Update existing packages, Schedule jobs and maintaining existing jobs.
• Develop Conversion for MS Access Code to SQL SERVER \SSIS.
• Working on Data Migration on Client, Vendor and Financial data from legacy systems.
• Tuning existing SSIS packages for better performance.
• Working on migrated packages to make it compatible with SSIS 2012 from DTS 2000.
• Every day Statue meeting with management and technical discussion with offshore team to resolve their issues and assign task.
• Created the SSIS packages and scheduled them.
• Extracted data from SQL Server using load it into a single data base repository.
• Design and Developing SSIS interfaces.
• Applied data cleansing techniques to ensure consistency amongst data sets.
• Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
• Data analysis, problem solving techniques to enable continuous business process improvement

Environment: SSIS 2012, Windows 7, MS ACCESS SQL SERVER 2012.

Confidential -White Plains

SQL SERVER\BI Developer

Responsibilities:

• Working as SQL\BI Analyst\Developer for web based application.
• Daily Job includes Database development, Data loading through SSIS and Report creation.
• Working on Data Migration Project which includes designing new SSIS Packages, Update existing packages, Schedule jobs and maintaining existing jobs.
• Tuning existing SSIS packages for better performance.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Troubleshoot BI tool problems and provide technical support as needed. Perform other tasks as assigned.
• Worked as an Analyst to figure out performance issues and to provide solutions to resolve them.
• Report creation through SSRS to support Donation Calculation.
• Useevent handling to send E-mail on eventlike on error.
• Developed SSIS Packages to generate the reports in Excel sheets required by the managers for analysis.
• Design/Develop complex queries efficiently as per the given business requirements.
• Using Tortoise SVN for Sub Version and JIRA for issue tracking.
• Worked on Data Migration on Formulated data from legacy systems.
• Worked for Check processing System - get files through FTP and load data into Relational database via stored procedure.
• Worked on EDW project include package designing and redesigning, C# script, DWH Modeling
• Worked on Automated Report - Created a job which execute stored procedure and then export data into excel file at network location.
• Worked on C# Script to handle non printable characters before loading it to Cubes.

Environment: SSIS 2008 R2, SQL Server 2008, Windows 7, SVN, JIRA, C# .net.

Confidential, Southborough, MA

ETL/SQL Server/BI Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements.
• Analyze different business requirements and provide time estimate for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move).
• Perform ETL processes using SSIS tool for SQL Server
• Design/Develop complex queries efficiently as per the given business requirements.
• Created database fact/dimension tables, views, stored procedures, functions and triggers as required.
• Worked on Table Partitioning to load current and historical data.
• Worked with Business users to understand the Business Logics as per the need.
• Worked with Financial data to calculate Comp.
• Develop views, sub-queries and joins for complex queries involving multiple tables Created joins and sub-queries for complex queries involving multiple tables.
• Used various transformation tasks to create ETL packages for data conversion.
• Loaded flat files data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Implemented changes in Cubes (SSAS) as per the requirement.
• Created a cube in existing system and their respective Facts and Dimensions, Relationship and Partitioning.
• Worked with SSAS cubes using multiple dimensions, perspectives, hierarchies, measures groups to analyze performance of System.
• Created Transact-SQL(stored procedures, views, triggers, sub-queries, joins)
• Generated reports using SQL server reporting services (SSRS).
• Scheduled Jobs and Alerting using SQL Server Agent.
• Design/Develop Test Plans, Test Cases and documentation of various processes involved.
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.
• Enhanced performance using optimization techniques like normalization, indexing and monitoring logs to ensure the completeness of batch processes, Scripts and processes.
• Documentation of all the processes involved in maintaining the database for future reference.
• Responsible for maintaining and supporting production databases.
• Created standard report subscriptions.
• Created report snapshots and cache for better performance.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Perform /coordinated end to end Migration process in TEST /PROD ENV.
• Created C#.Net Script for Data Flow task to fetch data from server and load it into database through Script component.
• Deployed and processed SSAS cubes daily/Weekly to update information using SQL Server Agent.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.

Environment: SSIS/SSRS/SSAS, SQL Server 2008, VB.NET Query Analyzer, Windows 7, Team Foundation Server (TFS) NET Framework 2.0.

Confidential, Wayne, NJ

ETL/BI Developer

Responsibilities:

• Work with BAs, DBAs and other Developers to understand the existing system.
• Make analysis and development plan accordingly.
• Work with DBAs to migrate databases from SQL Server 2005 to SQL Server 2008.
• Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL in SQL Server 2008. Involved in designing the Data Warehouse of TYPE 1 and core Database for the system using Snowflake Schema including tables, views, stored procedures, Indexes etc. in SQL Server 2008.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system (CPODS) to Staging Environment and finally in Data Warehouse.
• Redesigned complicated SSIS packages from scratch after applying necessary transformations.
• Add XML configuration files to each package to deal with different servers like Development, Testing and Production.
• Make use of Script Tasks to rewrite script code in SSIS.
• Mainly responsible for the maintenance of dataware house and monitor jobs and ensure all packages are running without any interruption to users worldwide.
• Rework on migrated packages to make it compatible with SSIS 2008.
• Changed Stored Procedures, Functions, Views, and Triggers to add new features of SQL Server 2008.
• Experience in query optimization & performance tuning using SQL Profiler, Execution Plan and Performance Monitor.
• Rework on migrated packages to make it compatible with SSIS 2008.
• Created Table, Matrix, drill down, drill through, and parameterized reports based on the requirements through SQL Server Reporting Services (SSRS).
• Deployed and Subscribe Reports using SSRS to generate Daily, Weekly, Monthly Reports.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Helped in creating new component in SSIS called Partition Tasks in C#.net that creates partitions for the cubes and drops partitions based on some criteria.
• Diagnosing and tuning the server optimal performance using SQL Server Profiler and Index Tuning.
• Documentation of all the processes involved in maintaining the database for future reference.
• Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2008/2005, SQL Server Integration Service, Business Intelligence Development StudioT SQL, SQL Server Management Studio, C#.net.

Confidential, Oaks, PA

ETL Developer

Responsibilities:

• Evaluate technical requirements, lead development effort all the way to Prod migration including development, testing.
• Experience in all phases of the development life cycle including Requirements gathering, Analysis, Design, Development, & Testing.
• Involved in creating and maintaining database objects such as indexes, views, stored procedures, and user defined functions in T-SQL.
• Designed SSIS packages to efficiently handle heterogeneous and unusual data from various external sources.
• Secured and Configured SSIS packages for deployment to production using Package Configurations and Deployment Wizard.
• Created SSIS Packages using Derived Columns, Condition Split, Merge Join, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. in SQL Server Integration Services 2008. (SSIS).
• Designed SSIS packages and schedule them in jobs to load OLTP data every hour.
• Actively involved in system performance by tuning SQL queries and stored procedures by using SQL profiler.
• Wrote complex T-SQL statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity.
• Created Alerts for successful or unsuccessful completion of scheduled jobs.
• Used SQL Server Reporting Services (SSRS) for creating drill down, drill through, and parameterized reports based on the requirements.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Scheduled the reports to run on daily, weekly basis in the report manager.
• Create various support documents like Business Requirement Documents, Mapping Documents, and Deployment plans.
• Actively participated in User Acceptance Testing, and debugging of the system.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL server 2005s Profiler and Index Tuning Wizards.

Environment: Microsoft SQL Server 2008 R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), Server Business Intelligence Development Studio.

Confidential

ETL-Informatica/PLSQL Developer

Responsibilities:

• Based on the requirements, created Functional design documents and prepared the Technical design specification documents for ETL Process.
• Designed, developed and maintained Insurance policies and claims transactions Data Mart using Informatica Power Center.
• Analyzed, Designed, Developed, Maintained and tested AXA Banking and Insurance application.
• Designed and developedto extract data from different sources like, Oracle tables, DB2tables, and Flat files.
• Designed and developed mappings, enabling the extract, transport and loading the data into target tables.
• Updated centralized repository on daily basis, so as to provide recent data to other applications and to generate accurate reports.
• Created Complex mapping using Expression, Aggregate, and Lookup, Sequence generator, Update Strategy, Stored Procedure and Router transformations.
• Wrote PL/SQL commands as pre and post session tasks.
• Designed and developed table structures, stored procedures andfunctions to implement business rules.
• Designed/developed core Java/MQ Series server-side modules for processing different Insurance types.
• Designed/developed C++ based AXA customer service application for communicating with Java server-side modules via MQ Series.
• Created various LINUX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using LINUX Shell Scripts.
• Used SQL Loader for data loading from external files into the Oracle database
• Developed Unit Test Cases and document them as per Project standards.
• Test data integrity among various sources, targets and various performance issues.
• Troubleshoot problems by checking sessions and workflow logs.
• Conducted training sessions and knowledge transfer to help internal team members.
• Responsible for Migrating the Informatica Processes from development to Test and production environment, set up security, groups and roles as well as define development standards and reviewing scripts to ensure they comply with guidelines.

Environment: Informatica 6.1/7.1,7.3 C++, Core Java, Mainframe, Flat Files, Shell Scripts, Windows 2000, Oracle, Linux, Power++, COBOL, JCL, SQL/PLSQL, SQL*Loader, Toad.