SUMMARY

• Highly motivated Information Technology Professional with Over 8+ years of experience with a strong background in Data warehousing projects development and ETL & Reporting experience using SQL Server SSIS/SSRS in various Industry verticals like Finance, Telecommunications, Insurance and Health Care.
• Familiar with the entire phases of Software Development Life Cycle (SDLC) of SSIS Package Development from blueprinting to development, testing, implementation and post - implementation support.
• Financial Investment Experience in developing solutions for AUM(assets Under Management), involved in defining Portfolio and Security Master, building Trading/Finance reports based on different products (Fixed Income, Equity, Structure, Alternatives etc.)
• Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2012/2008 R 2/2008/2005.
• Experience in Extraction, Transforming and Loading (ETL) using SSIS creating mappings/workflows to extract data from SQL Server, Oracle, Excel file, DB, Access DB and Flat File sources and load into various Business Entities.
• Expertise in SSIS direct and Indirect Configuration(XML, SQL Server) set up, SSIS Audit and Logging, Error Handling, Expressions and Variables.
• Expertise in performance tuning of Data Flow Task in SSIS Packages.
• Experience in creating Historical and Incremental Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Expertise backend skills in creating SQL objects like Tables, complex Stored Procedures, Views, Indexes, effective Functions and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in report writing using SQL Server Reporting Services and in creating various types of reports like Drill Down, Drill Through, Parameterized, Matrix, Chart Report, and Web reporting by customizing URL Access.
• Expertise in writing T-SQL (DML & DDL) Code, Dynamic SQL, Query optimization & performance tuning. Used SQL Profiler, Execution plan, Performance Monitor and DBCC commands.
• Experience in migrating databases from SQL Server 2005 to SQL Server 2008.
• Expertise in Creating Cluster Index and Non Cluster Index, Covered Index, and Indexed View to improve performance on Database side.
• Experience in Dimensional Modeling, ER Modeling using Erwin, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Expertise in deploying SSIS Package, SSRS Reports and SSAS Cubes using command line utilities.
• Excellent skill and strong understanding in Testing SSIS, SSRS, TSQL objects.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to understand and develop creative solutions for challenging client needs.
• Ability to work independently and efficiently, managing timelines and expectations.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005/2000
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• MS SQL Analysis Services (SSAS)
• Microsoft Access 2007/2003/8.0
• Microsoft Word
• Excel
• PowerPoint
• Outlook
• T-SQLSQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• MS SQL Profiler
• Erwin Data Modeler 7.2/4.2/4.1/4.0
• Crystal Reports 8.5
• MS SharePoint Designer 2007
• MS SharePoint Services 2007
• MS Visio 2003
• Windows Server 2003

PROFESSIONAL EXPERIENCE

Confidential, New York NY

MS SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Actively participated in development and implementation of AUM Data Warehouse, including the integration of Private Investment, fixed income, equity, Alternatives and Structured Products.
• Designed the base template SSIS packages as a standard for all developers. Worked on SQL Server Integration Services to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, SQL 2008, and Oracle)
• Created SSIS Framework to validate (Column Header, Filename, and Row Count) and Created Report SSIS Framework to generate Custom Excel report based on Business requirement.
• Created SSC DW Load SSIS Framework/SSIS Packages to load Incoming SSC files to ODS and ODS to DW after cleansing, scrubbing the data files( used combination of complex TSQL query and SSIS Package)
• Key role in implementing a standardized process for deployment of reports with multiple sub-reports/ linked reports.
• Configured Reporting Manager for subscription, email notification, drill down reports and users security.
• Developed report models for users to create reports on demand.
• Created/updated SP, Triggers, User Defined Functions, User defined data type, Scripts and batches.
• Performed quality assurance and testing of SQL server environment.
• Use For-Each Loop Container, Sequence Container, Script Task, Execute SQL task, Variables, Send Mail Task, Package Execution Task in Control Flow and Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split Transformation to manipulate data in SSIS package Data Flow.
• Provided Dynamic Configuration, Custom Package Logging, Error Handling, and Notification to SSIS template package. Created packages including extraction from flat files, excel file, oracle and load data to SQL server.
• Created reconciliation reports based on user needs to support security and portfolio third party data validation. Specifically for BARCLAYs POINT upload.
• Created 10 AUM (Including Gain/Loss Report) reports using C# scripting in Script task to handle custom formatting of excel sheet.
• Created reconciliation report based on holding by Portfolio file receiving from State Street and comparing it with MAGIC DW..
• Used transformation like Merge Join, Pivot, lookup, Fuzzy lookup and slowly changing Dimension.
• Use Package Configuration to Migrate SSIS package from one environment to other.
• Created SSIS Framework to generate excel report with formatting using Excel Assembly and C# code in Script Task. Customize run based on custom report definition schedule table.
• Actively involved with BA to write production support escalation document and RunBook based on Vendor/Client SLAs and available to support by 24/7.
• Supporting the entire development process

Confidential, Warren, New Jersey

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Created Database objects - tables, views, and functions.
• Rebuilt Indexes and Tables as part of performance tuning exercise
• Set up some tables in the main server as a snapshot publication and push them to the warehouse server (Subscriber) on the nightly basis. This eliminated the old way of emailing spreadsheet on the weekly basis.
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory.
• Successfully implemented physical database design in SQL Server 2008R2.
• Created Indexed Views to facilitate easy user interface implementation and enforce security on critical customer information.
• Wrote Triggers and Stored Procedures and T-SQL Queries to capture updated and deleted data from OLTP systems.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data from ODS to related destination databases for residential, business, large business users.
• Implemented the elements of T-SQL like dynamic stored procedure to store and update the information regarding residential, business and large business customers into one centralized SQL database called hub.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like Retailers Debit, Credit etc.
• Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed
• Generated Drill- through, Drill down, Matrix, Snapshot reports using the data from the Data warehouse using SSRS with Microsoft Share Point Integration 2007.

Confidential, Los Angeles, CA

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involved in Logical, Physical design and Development of the DSR (Data Staging Repository) for the Database and AMS (Asset Management Reporting System) using Erwin.
• Defined Check constraints, Business Rule, Indexes and Views.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Installed and configured MS SQL Server 2008R2 along with Visual Studio on a network domain system.
• Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to AMS database.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and more using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Scheduled Jobs to run SSIS package in night feed to AMS for fresh day data. Load data form AMS database to Data warehouse using SSIS packages.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008R2.
• Defined report layouts, report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Created parameterized, drill down and aggregation reports using SSRS 2008R2.
• Administered interface to organize, schedule report execution, delivery, and track history using SSRS 2008R2.
• Responsible for the Performance tuning.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Responsible for Backup and Recovery Strategy and Planning.

Confidential, Hartford, CT

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Analyzed, enhanced and maintained Data Warehouse systems utilizing RDBMS database (Primarily in MS SQL Server) & utilities and SQL scripts.
• Participated in project scope identification, data architecture development and project planning in coordination with other members of the data warehouse team.
• Practiced SDLC for planning, design, analysis and implementation of the project.
• Managed ETL program and mapping development (specify, develop, test, deploy) utilizing a defined project methodology and internal standards.
• Responsible for leading the development team to ensure database integrity.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Created data-related documentations, relationships and attributes.
• Created ER diagrams (logical design) by ERWIN tool and mapped the data into database objects
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Developed data transformation processes, automating load processes and maintain and update acquisition and loading processes.
• Administered monitoring systems and remedial processes to ensure data loads always occur on schedule and data is accurate.
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created and tuned Indexes to get the high level performance.
• Performed the ETL operations to support the data loads and transformations using SSIS.
• Defined and capture metadata and business rules in coordination with other data warehouse team members to support the projects
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.

Confidential, Lansing, MI

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Migrated from SQL Server 2005 to SQL Server 2008.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Responsible for performance tuning of existing SSIS packages and introduced dynamic configurations, custom logging, Error Handling etc.
• Created the workflow documents for all existing and new SSIS packages.
• Responsible for Troubleshooting Report Processing, Subscription, Delivery and Configuration
• Developed Query for generating drill down and drill through reports in SSRS.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Reported solutions to improve asset management, incident management, system events support and billing.
• Successfully migrated data between heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Created SSIS packages architecting the flow of data from various heterogeneous sources into target.
• Implemented and supported OLAP reporting user interface enabling ad-hoc queries and multidimensional views for data analysis.
• Monitored performance and optimized SQL queries for maximum efficiency and implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Designed database objects like indexes, views, user defined functions, triggers, stored procedure, constraints, and roles and documented all the procedures involved in the database for future .

Confidential, Atlanta, GA

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created Stored Procedure, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality Implemented backup and database maintenance plans.
• Built SQL Server Integration Services (SSIS) Packages for data transfer from heterogeneous data sources using T-SQL Stored Procedures.
• Created and monitored SQL Server automated jobs to transfer data between various data sources using SQL server agent.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Used profiler to find badly performing queries and deadlocks.
• Designed and implemented ETL (Extraction, Transform and Load) for data migration and data staging from heterogeneous environment like MS Access and MS Excel using SQL Server Integration Services (SSIS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server reporting Services (SSRS), and Crystal reports.
• Worked with Database Consistency Checks (DBCC) to ensure the physical consistency of the database and objects.

Confidential, Hartford, CT

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 and Oracle 10g using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS packages to Validate, Extract, Transform and Load data to DW and Data Mart Databases.
• Created various Parameterized Reports, Drill through Reports using SSRS 2005.
• Generated ad hoc reports using MS Reporting services.
• Reports were scheduled to be delivered by Email and File. Created Dashboard reports using SSRS.
• Generated reports using SSRS that were used to send information to different Primary vendors, Clients and managers.
• Formed and developed the stored procedures, triggers to handle complex business rules, data conversion, historical data, and audit analysis.
• Implemented a well-planned backup and restore strategy that protects databases against data loss.