PROFESSIONAL SUMMARY:

• Highly motivated IT Professional with Over 5+ years of experience with strong background in SSIS/ETL(Extract, Transform and Load) & Reporting projects development and DW using SQL Server SSIS/SSRS in various Industry verticals like Banking, Retail, Finance .
• Experience in using BI tools(SSIS,SSRS, SSAS) in MS SQL Server 2005, 2008, 2008R2, 2012, 2014,.
• Conversant with all phases of SDLC - Systems Analysis, Design, Development and implemetation
• Implemented complete BI solutions using conventional SDLC and Agile methodologies.
• Coordinated with several onsite and offshore development team.
• Specialized in managing projects from gathering requirements through implementation.
• Hands on experience in Installing,Configuring, Managing, Monitoring & troubleshooting SQL Server.
• Excellent skills in writing complex SQL queries involving multiple tables(Join), ability to develop and maintain views, stored procedures, triggers and user defined functions.
• Experience in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts.
• Experience in Performance Tuning and Query Optimization.
• Expertise in implementing complex ETL packages to extract data from various sources (SQL Server, Oracle, Excel file, DB2, SharePoint lists and Flat File) and load into various destinations.
• Proficient in creating dynamic packages for Incremental Loads & Data Cleaning in DW using SSIS.
• Experience in error & event handling: Precedence Constraints, BreakPoints, CheckPoints, Logging.
• Expertise in performance tuning of Data Flow Task in SSIS Packages.
• Expertise in file system deployment, deploying SSIS Packages using command line utilities and executing packages through a batch file (.bat).
• Experience in creating Historical & Incremental Jobs, Alerts and SQL mail agent for SSIS packages and scheduling Jobs through SQL Server Agent Job and TWS (Tiwoli Worker Scheduler).
• Worked with various Version Controlling tool (TFS, VSS & SVN)of SQL Scripts and SSIS Packages.
• Generated various Daily, Monthly, Quarterly reports using SSRS. Created various types of reports like Drill Down, Drill Through, Sub Report, Parameterized and Charts.
• Experience in logical and physical data modeling and database design using Erwin.
• Experience in writing Deployment Docs(SIT/QA/Prod), Test Scenarios, Mapping & Release docs.
• Flexible, enthusiastic and project oriented team player with excellent written, communication and leadership skills to understand and develop creative solutions for challenging client needs.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS:

ETL: SSIS (expert); Informatica (trained)

Reporting: SSRS (expert);

Database - SQL: SQL (expert) SQL Server 2005/2008/2008 R2, Oracle, DB2, MS Access, Netezza

O/S : Windows 2003, XP, Vista, Android

Tools/Technologies: Transact SQL (T-SQL), SSIS, SQL Server 2005/2008/2008 R2/2012, MS BI Studio, SSRS, TFS, SVN, Netezza, C#, VB.Net, XML, MS Excel, MS Visio, Visual Source safe, Erwin Data Modeler, JIRA, Service Now.

PROFESSIONAL EXPERIENCE:

Confidential, New York

SQL Server/SSRS/SSIS Developer

Roles and Responsibilities:

• Develop, and maintain SSIS packages and SSIS batch jobs involving complex source data.
• Design and develop T-SQL procedures, SQL performance tunings and SSIS packages.
• Perform and execute data extraction, transformation and loading using ETL tools.
• Develop underlying data models and databases.
• Ensure compliance of standards and conventions in developing programs.
• Translate business requirements into software applications and models.
• Respond to service requests in line with established SLAs and turnaround times
• Responsible for the design, development, maintenance and support of various ETL application and programs within the Line of Business
• Develops new documentation, participates in the development of department technical procedures and designs user guides.
• Ensure the implementation schedule is on track and performance defects are brought to closure - Performance Testing
• Lead development team members and contract resources, including providing necessary guidance to prepare SDLC and technical documents, troubleshoot and resolve production issues. . working closely with internal departments and internal IT team to turn data into critical information and knowledge that can be used to make sound business decisions.
• Analyze user needs to design, develop, and modify software solutions
• Work with project manager and product owners to meet specification needs
• Collaborate with other developers to design and optimize code
• Create flowcharts and user guides for new and existing programs
• Document all programming tasks and procedures
• Perform routine software maintenance

Tools & Technology: MS SQL Server 2014, T-SQL, SSIS (SQL Server Integration Services), T-SQL, Query Analyzer, TFS, SQL profiler.

Confidential, New York City, New York

MS T-SQL/SSIS/SSRS Developer

Roles and Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Participated in requirement gathering, application design and training operational users.
• Developed SSIS (ETL) packages for loading data from OLTP system
• Created SSIS Framework to validate (Column Header, Filename, and Row Count) and Created SSIS Framework to generate Custom Excel report based on Business prerequisite.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL Code.
• Implemented various reports in SSRS such as Sub-reports, Parameterized, Drill-through, Drill-down reports, Matrix reports, Summary reports, Tabular Reports etc.
• Configured Reporting Manager for subscription, email notification and users security.
• Developed report models for users to create reports on demand.
• Key role in implementing a standardized process for deployment of reports.
• Installation and configuration of TFS (Team foundtion server).

Tools & Technology : MS SQL Server 2008R2/2012, SSRS 2008R2, SSIS 2012 (ETL/SQL Server Integration Services), T-SQL, TFS.

Confidential

MS SQL Server/SSIS Developer

Roles and Responsibilities:

• Worked on creating Alco Report which shows the sum of balances and number of accounts for Deposits based on each product across different Regions/Area. The products include Now Checking, Business Checking, Business MMA Checking, Business Savings, Money Market Checking, Money Market Savings, Passbook, Liquid CD's, Certificate of Deposits.
• Created subscriptions/data driven subscriptions to provide timely reports to the clients and end users and Deployed the reports on share point.
• Studied the existing OLTP systems & interacted with Data Architect regarding facts, dimensions and star schema representation for the data mart & Worked on DataMart for Deposits & Loans data.
• Worked on different sources for Loans like Automated Financial Systems (AFS), Installment Loans (IL), Mortgage Loans (ML) and Deposits like Direct Deposits (DD), Checking's (CD), Savings (SV).
• Created SSIS packages to pull data from SQL Server, exported to Excel Spreadsheets and vice versa.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Involved in Designing & Testing of the ETL strategy to populate the data from various source systems feeds using SSIS.
• Designed the base template SSIS packages as a standard for all developers. Worked on SQL Server Integration Services (SSIS/ETL) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV,Excel, SQL 2008, and Oracle).
• Designed ETL auditing of package and underlying tasks into a database table, to help in performance tuning and error handling/Redirecting rejected records.
• Created and managed T-SQL objects such as Tables, Views, Indexes and created complex store procedure using input and output parameter.
• Wrote T-SQL queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE and ranking function.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.

Tools & Technology : MS SQL Server 2008, T-SQL, SSRS / SSIS, Visual Source Safe, Microsoft Visio 2007, Oracle, CSV, MS Excel.

Confidential

MS SQL Server /SSIS/SSRS Developer

Roles and Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project.
• Designed and implemented the Logical and Physical model of the database using Erwin.
• Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS (Data Transformation Services).
• Developed complex programs in T-SQL (DML & DDL) Code, Dynamic SQL, Query optimization, performance Tuning & Used SQL Profiler, Execution plan, Performance Monitor & DBCC commands.
• Worked in SQL Server Agent for job scheduling and batch files.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, and Table Structures.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) & loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Performed ETL operations on data from multiple input sources and loaded data into SQL Server.
• Used Lookup transform to create the SSIS package for inserting the new entry from excel master source spreadsheet to the SQL Server table and update the old data.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS.

Tools & Technology: MS SQL Server 2008, Query Analyzer, T-SQL, Excel, SQL Server Integration services(SSIS), XML, Erwin, DTS.