SUMMARY

• 8+ Years of IT Experience in Data analysis and Business Intelligence Technologies with expertise on ETL process, SSIS, SSRS and SSAS.
• Experience as a data analyst in Supply Chain Management, Drug diversion, and Facets provider data
• Source to target mapping using excel and IBM Fast track tool. Analysis of the source data, analyzing the logic, coming up with the transformations and passing it to the developers to use as reference of the business logic and requirements
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Strong working experience in SQL Server and T - SQL in constructing triggers, tables(DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert and Change Data Capture
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, and Parallel processing
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Very well aware of the changes made to Configuration files and deployment models and other changes in SQL Server 2012. Used TFS for version control and project tracking.
• Experience in deploying packages to Integration Services Catalog in SQL Server 2012
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Work with DBA’s on Production issues and provide resolution.
• A thorough professional with proactive attitude, out of the box thinking and generating new ideas.
• A keen communicator with the ability to relate to people across all levels in the organization.
• Participated and contributed in code reviews
• Have worked in rapid development/ agile model- with everyday scrums and 3 weekly sprint deliverables.

TECHNICAL SKILLS

BI Tools: SQL SERVER 2005/2008/2012 SSIS, SSAS, SSRS

Languages: C#, VB.NET, C, T-SQL, SQL, PL/SQL, Visual Basic 6.0, VBA, HTML, VB Script, Jscript

RDBMS: MS-Access, Oracle 8i/9i, MS SQL Server 2000/2005/2008/2012 , MS-Access, DB2

Operating Systems: Microsoft Windows 98/2000/2003 Server/XP/7/8/2008 Server/2012 Server

Application Package: MS Office Suite, Visio, IBM Stack

Analytical Tools: SAS, R, MS-Excel (VBA), SPSS, Spotfire, Tableau, IBM Info analyzer, IBM Fast track, IBM Data Stage, Rapid SQL, AQT, HP Quality Center, TFS

PROFESSIONAL EXPERIENCE

Data Analyst / SSIS Developer

Confidential, VA

Responsibilities:

• Worked as a data analyst and SSIS Developer for Facets Provider data
• Understanding the data model, data profiling, de-duplication of data, Source to Target mapping, look ups and transformations in excel, working with the development team to meet business requirements and logic. Master Data Management and data Governance and coordinating with the users to gather business requirements
• Writing source queries to pull data from Oracle Facets source for SSIS package. Parallel processing in sequence containers, e-mail notifications, row count verification, creating package level variables, data conversion task, execute SQL task for stored procedures, DML Changes Updating parameters, indexing properties, evaluating expressions, Creating variables to hold source queries, creating dynamic queries and aggregating tables, running packages in dev, QA and Prod, executing script task with stored procedures. Experience in configuring, deploying and scheduling packages
• Creating tilde delimited extract files for users. Used Ultra edit to test extract files.
• Data validation, tracking and documenting changes, using TFS Unit testing, User Acceptance testing to check extract files. Assisted in migration to SQL Server 2014.

Environment: SSIS, SQL Server 2012, Oracle

Data Analyst

Confidential, Rochester, MN

Responsibilities:

• Worked extensively as a data analyst for the data warehousing projects in the supply chain management and Office of Population Health Management. Worked extensively with the business users to gather requirements
• Data analysis and data profiling, de-duplicating records following physical data model consisting of data marts, snowflakes and fact tables, source to target mapping, look ups and transformations. Data Governance and standardizing data and master data management
• Used several IBM tools like Info Analyzer, Data Stage and Fast track to analyze the data.
• Writing complex queries, aggregating tables, truncating, dropping, modifying tables joins and source queries to pull data from other sources in order to integrate in the data warehouse, Full and Incremental loads,
• Worked with the concepts of Slowly changing dimensions, junk dimensions, bridge tables, normalized and de-normalized data.
• Source to target mapping in IBM Fast track tool for various target to source tables and look ups in order for the developers to perform ETL.
• Testing the data through Quality Center, documenting changes and updates, testing the cubes and used TFS for project tracking
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems
• Updating parameters in Data Stage and creating sequencers.
• Designed scalable, flexible, and affordable data warehouse models, created surrogate keys and worked with bridge tables.

Environment: DB2, SQL Server 2008, IBM Stack

BI Developer (SSIS/SSRS/SSAS)

Confidential

Responsibilities:

• Formulated and documented ETL process design based on business requirements from customers and system specifications including source to target mapping and transformation.
• Involved in business analysis, data profiling and technical design sessions with business and technical staff to develop dimensional models, requirements document, MDM, update changes, ETL specifications: Slowly changing dimensions, junk and degenerate dimensions.
• Processed bridge tables, aggregate tables and surrogate keys and worked on full and incremental loads
• Worked on Performance Tuning, SSIS packages error handling.
• Created database objects like Procedures, Functions, Triggers, Indexes, DML changes on tables
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities, row count, sorting, notifications, security
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages. Running packages in all environments
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, Conditional Split etc. as part of ETL. Worked with Change Data Capture Task
• Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files
• Debugged stored procedures optimize Stored Procedures
• Modified star schema and identified the requirement of snow flake schema in the design
• Extensively used Merge command as alternative to small SSIS packages in dimension and fact load
• Deployed SSIS packages with minimal changes using XML configuration file. Used transformations like derived column, row count, send email task, script task for notifications and security
• Migrated packages from legacy systems (DTS-SSIS) and deployed the packages across Dev/UAT/Prod environments.
• Created and scheduled packages using incremental load and SCD. Developed and Extended SSAS Cubes, Dimensions and data source views, Data Mining Models and Deploying and Processing SSAS objects.
• Identified the requirement of partitioning the cube for better query performance
• Loaded fact and dimension tables as part of modified data warehouse solution
• Built an Analysis Services database on already existing data warehouse solution
• Created measures, measure groups, dimensions and multi-dimensional cubes
• Worked on back up of cubes, aggregations and dimension level security of cubes
• Created SSRS Reports: involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters Tablix control. Created Dynamic CRM reports and also involved in Dashboard reporting, Share Point with Power View tool, TFS etc.
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, SSRS, SSAS

SQL BI Developer

Confidential

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables: both full and incremental load, by performing different kinds of transformations like row count, derived column, merge, look up using SSIS packages and truncating, modifying and creating tables in data base as per requirements
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created checkpoints and configuration files in SSIS packages and migrating to various environments
• Implemented slowly changing dimensions, junk and degenerate dimensions, surrogate keys.
• Upgrade packages from SSIS 2008R2 to 2012.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture, used script task for customizing
• Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and FTP.
• Generated various reports by data profiling and analyzing aggregate tables and de-duplication with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules as per the Client requirements
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and Named queries.
• Involved in defining referenced relationships with measure group and fact tables, and Master Data Management and version control through TFS.
• Defined Granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server and documenting updates and changes

Environment: SQL Server 2012, SQL Server 2008R2, SSIS, SSRS, SSAS

MSBI Developer

Confidential, Hackensack, NJ

Responsibilities:

• Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files by data profiling and data analysis
• Extensively used Merge command as alternative to small SSIS packages in dimension and fact load-full and incremental load and migrating to Dev, QA and Prod. Migration of packages to other versions of BIDS.
• Used Slowly Changing dimensions, junk and degenerate dimensions. Processed surrogate keys
• Deployed SSIS packages with minimal changes using XML configuration file
• Involved in business analysis and technical design sessions with business and technical staff to develop dimensional models, requirements document, and ETL specifications, using script task . Processed both full and incremental load. Maintenance of OLAP cubes, data profiling and auditing.
• Created database objects like Procedures, Functions, Triggers, Indexes, DML and DDL changes
• Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems and data management by working with the end users. Documenting updates and enhancements to project
• Used SQL Profiler to optimize Stored Procedures, TFS and ftp files
• Designed scalable, flexible, and affordable data warehouse models

Environment: SQL Server 2008, SSIS, SSRS, SSAS, BIDS

SSIS/SSAS/SSRS Developer

Confidential, N.J

Responsibilities:

• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations for Confidential t data, data profiling, analysis
• Worked on ICD-9 Coding and Insurance claims and Master Data
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data warehouse: full and incremental load. Migrated packages to other SSIS versions, deployed and scheduled
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases, dropping and creating tables
• Writing and Debugging T-SQL, stored procedures, Views, aggregating tables and User Defined Functions, indexing, migrating packages to various environments
• Extracted data from Txt/CSV/XML/Oracle/Sybase to SQL server and used script task for customization
• Worked on Slowly Changing Dimensions, junk and degenerate dimensions, surrogate keys,
• Experienced in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS, Data Mining Models and Deploying and Processing SSAS objects.
• Developed and Deployed different types of Reports like List, Drill Down, Matrix, Chart and Sub Reports etc. with SSRS
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder and documenting enhancements

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, SAS, Excel

SQL/BI Analyst

Confidential

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS
• Handled migrations from DTS to SSIS 2005 and and to various dev, QA and Prod environments
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions, modifying existing tables, dropping and truncating tables and creating new tables when required
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Data migration (import & export - BCP) from Text to SQL Server
• Error handling using Try-Catch Block
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Prepared daily and weekly status reports and collaborated with other team members
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity
• Customized the stored procedures and database triggers to meet the changing business rules
• Implemented indexes for performance tuning
• Data loaded into the database using SSIS 2005 from flat files

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel, R