PROFESSIONAL SUMMARY:

• Around 8+ years of Experience in Microsoft BI tools and in the field of Data Warehousing as a Data Analyst and Data Modeler.
• 5+ years of experience on performing Data Analysis from source systems to data mart and provide root cause analysis for defects.
• Worked on migration of Teradata DB to Hadoop. Used Query IT tool to access Hadoop files
• Facilitating JAD (Joint Application Development) sessions, gathering and documenting Business Requirements.
• Creating Technical Design and Architecture documentation including Data Flows, Source to Target Mapping
• 4 year of experience with Erwin modeling suite: Erwin Data Modeler, Erwin Data Model Validator , Erwin Data Profiler, Erwin Model Manager, Erwin Model Navigator.
• Facilitating JAD (Joint Application Development) sessions, gathering and documenting Business Requirements.
• Experienced in data modeling skills including conceptual, logical and physical for OLTP, OLAP and Data Warehouses.
• Experienced in performing Normalization on tables and designing tables using relational modeling.
• Proven expertise in all phases of AGILE and Software Development Life Cycle (SDLC).
• Experience in writing complex SQL queries, procedures, functions, packages, cursors, exception handling, triggers, collections and performance tuning.
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012 for Batch Processing using DDL, DML, DCL commands for various business applications and Data warehousing Systems (SSRS, SSIS, SSAS)
• Experience in database programming in writing T - SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Worked on Insurance projects in health care industry, Medical Claims Experience.
• Experience in developing SSIS packages to bring data from Insurance Claims databases to data warehouse tables.
• Knowledge of SSIS Including Data flow component, control flow component, SSIS Logging, SSIS Configuration, SSIS Security. SSIS Error handling
• Knowledge in SQL Server database including SQL Queries, joins, functions, trigger, store procedure.
• Knowledge in agile, sprint development projects, data warehouse concept, basic knowledge in scripting language like C# or VB.
• Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning.
• Experience in migrating DTS packages, reports and analysis services projects from SQL Server 2005 to SQL server 2008R2 and 2012.
• Involved in Huge Data Migrations and Data Transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Good knowledge in Tuning SQL queries & improving the performance of the Database.
• Strong complex reporting skills - complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports.
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008)
• Expert in creating Parameterized Reports.
• Experience in deploying Reports to Report Server . Creating user interface on Report Server for the users to access reports on Report Manager.
• Hands on experience in Creating Star Schema and Snow Flake Schemas.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Good understanding of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Experience in Creating number of cubes, dimensions and critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

Databases: MS SQL Server 2005/2008r2/2012,TERADATA,ORACLE

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, Business Intelligence Development Studio (BIDS).Oracle,Teradata,Netezza,Teradata, Erwin Data Model

Reporting Tools: SQL Server Reporting Services (SSRS) 2012/2008/2005 , SAP BW

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), BCP, SQL Server Analysis Services (SSAS)

Languages: C, C++, C#, T-SQL

Web Technologies: Web Services, XML, HTML

Operating System: Windows 98 /2003/NT/XP/7, MS DOS

Applications: MS Visual Studio 2010, MS office 2003/2007/2010 , HTML/DHTML, XML,Visual Studio IDE

Protocols: HTTP, TCP/IP, FTP

PROFESSIONAL EXPERIENCE:

Confidential, TX

Data Base Developer/ Analyst/Modeler

Responsibilities:

• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Coordinate with key stake holders, SME, Application owners and other analysts for business requirement gathering and analysis.
• Unwinding the existing logic in Oracle to create STT (Source to Target) documents.
• Identify ways of building new rules, insights, metrics, and data improvement approaches.
• Profile and analyze customer data against information quality expectations or specifications.
• Written stored procedures and used them in packages.
• Involved in high level architectural design discussions for designing the MDF(meta data framework) tables which store the business and supplier data.
• Analyzed the impact on the Enterprise data warehouse and Down streams.
• Analyzed the defects to find and document the root cause.
• Involved in migration of database from Oracle to Teradata
• Used T-SQL queries to insert the complete file information and layout to MDF tables.
• Used various expressions in designing file watcher which watches for the files dropped into SFTP site.
• Data loading using SSIS into different DW like Netezza.
• Designed SSIS Package to check the row count of the source and target tables of oracle source.
• Worked on SSIS Packages to load data from different source to target sql database using SQL 2008 and Sql 2012
• Worked on for each loop containers, sequence containers.
• Used various tasks like Execute SQL task which calls stored procedures and takes parameters, Script component task for reading the file and removing trailer records.
• Created source, stage and archive folders as per the requirements using expressions in file system task.
• Design Cubes and hierarchies in SSAS
• Used execute process task for unzipping the zipped files.
• Created package configuration using parent package as variable and used them to deploy packages into SQL server and various environments.
• Developed master package which calls the child packages and loads the files to stage and history tables in GDW.
• Errors in the file will be logged into the DIF (data integration framework) tables and an email will be sent to business people to get back to suppliers with file information.
• Avoiding the multiple load of the same file using flag column in MDF table. Accommodating MDF to handle new set of files.
• Scheduled Packages using SQL Server Agent Jobs to run every 5 min.
• Developed ETL Dashboard Monitoring reports, Execution summary reports.
• Developed parameterized, drill down, drill through and cascaded reports.
• Used TFS to check in and check out the changes made to code.

Environment: T-SQL, MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS),Team foundation Server(TFS), SharePoint, MS Excel, Windows 2008 R2, Microsoft windows server 2012.

Confidential, Richmond, VA

Database Developer/Modeler/Analyst

Responsibilities:

• Designed SSIS packages to transfer the data from DB2, flat files and excel documents to the Staging Area in SQL Server 2012.
• Used SQL Server Destination in Data flow to improve a great performance changes in Replications. (Admin rights for this operation).
• Used various Data Flow Transformations, like Derived Column, Data Conversion, Union All, Multicast and Copy Column while developing the packages.
• Used Event Handlers for Error Handling and Alert Operations.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Gathered the business requirement from the Billing System business user.
• Analyzed the impact on the Enterprise data warehouse and Down streams.
• Analyzed the issues to find and document the root cause.
• Created source to target documents up to EDW.
• Involved in migration of Database from Oracle to Netezza.
• Perform data and report validation using a report tools like Cognos Query Studio and Microstatergy.
• Involved in technical discussion to resolve the complex data issues and help developers on implementation.
• Used Informatica 9.1, Wincvs (SQL Scripts) tools to trace the logics from Source to EDW
• Scheduled Packages using SQL Server Agent Jobs, Monitoring nightly jobs.
• Used SSIS Variables for storing the values, which are used in various components of Data Flow Task.
• Created package configuration in XML and used them to deploy packages into SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output.
• Monitoring SSIS packages, Stored Procedures running in Agent job and support the Production Team.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Confidential, Minneapolis, MN

SQL BI Developer / Database Modeller

Responsibilities:

• Analyzed business requirements built logical and physical data models that describe all the data and relationships between the data.
• Written complex stored procedure according to the business requirements for reporting purpose.
• Developed SSIS Package using MS SQL Server Integration Services in such a way it loads last 4 days data from oracle into SQL Server database to store consistent and durable data.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Power Pivot, Drill-Down and Drill-Through Reports. Designed & developed the various SSIS packages for the Weekly & Monthly Loads from business users in different locations in United States.
• Data model are enhanced as the requirement changes.
• Stored procedure and functions are coded for the oracle package in PL/SQL Developer.
• Created views, triggers by using some Complex SQL scripts
• Performed reverse engineering on a database to sync Erwin data model with database model.
• Worked with DBA’s on Insert Scripts and DDL’s
• Performed Data Analysis/Profiling on data Source using Sql server Data Quality
• Involved in writing SQL queries to validate the data between source and target systems
• Good communication in verbal and oral to the project team.
• Managed the ETL processes between various environments through SSIS Configuration.
• Created Dashboards to present critical company data in a single report.
• Worked with various SSIS tasks including execute SQL task, for each loop container, file system tasks.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, and indexes depending on the requirement.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.

Environment: SQL Server 2008 R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), ORACLE 10g, MS Visual Source Safe and Windows Server 2008,.NET Framework, MS Office share point Server.

Confidential, Durham, NC

MSBI Developer

Responsibilities:

• Extensively used T-SQL in constructing user functions, views, indexes.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Good in script task. Validated the records which was retrieved from the database using c# code
• Got a good knowledge on Team Foundation Server (TFS),in which we use to maintain databases up to date and we also use TFS for storage of updated scripts and also to avoid the data loss.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Trouble shoots same SSIS packages by logging method before forwarding to quality analysis (QA) testing.
• Separated the body and header records using c# code in script task.
• Configuring SSIS packages when migrating packages from 2005 to 2008 R2.
• Validated the header records using script task(c# code).
• Experience in refreshing the databases and also know how to check with orphan users.
• Experience in working with SQL Server Agent Jobs and also scheduling the jobs to SSIS packages is my daily job.
• Used integration services (SSIS) to extract data in to the tables from i-batis (XML) files
• Involved in configuration and Maintenance of SQL server Agent Jobs
• Log files creation and improvement using Custom Component
• Developed SSRS report to analyze migrated data (Sales Force) for core objects and child objects.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, SSIS, C#, Share Point Windows Server, windows 7/XP, Visual Studio 2009 & TFS.

Confidential

Database Developer/Analyst

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Analyzed requirements from end users and identified various data sources and created Technical Specification Documents.
• Conducted sessions with business user to understand business rules and data structure.
• Instrumental in all the JAD (Joint Application Development) Sessions.
• Worked with different types of Sources like DB Tables source, Flat File Source, Excel Source and Destinations like DB Tables.
• Developed the Conceptual Models for various Data marts.
• Designed Normalized (1NF, 2NF, 3NF) database.
• Develop the Conceptual Models based on the reporting requirements.
• Involved in writing SQL queries to validate the data between source and target systems
• Involved in Data Modeling (Logical and Physical Design) of new tables using Erwin, and modeling of new attributes in existing tables design and implementation of Reporting Data
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed the Logical and Physical design of database for projects on basis of user requirements.

Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel.