SUMMARY:

• Extensive 8 years of experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2005/2008/R2/2012.
• Worked in Manufacturing Process, Banking Information Systems, andHealthCareManagement domains on various applications.
• Experience in SDLC life cycle for Design, Development and Staging phases of teh projects wif support of Data - flow. Thorough knowledge of Oracle and BI tools, Advanced Oracle database skills.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in hard coding of Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL.
• Experience wif T-SQL in constructing Tables, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Experience creating Tableau Dashboards connecting to multiple data sources like Oracle, SQL Server, Teradata and Excel Files Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports and MS Excel Power View.
• Advanced in Microsoft BI stack SSIS, SSRS, SSAS, Data marts, T-SQL, Partitioning, building dimensional models, stored procedures/functions/triggers, ETL.
• Working knowledge inAgile/Scrum Environment and used TFS (Team Foundation Server).
• Data Visualization expert on technologies like Tableau, Micro Strategy, Spot fire and TEMPhas gained expertise in these years in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth.
• Designed, developed and maintainedMDXqueries against SSAS cubes to generate reports.
• Developed Logical and physical data model using Erwin, ER Studio and mapped teh data into database objects.
• Wrote complex SQL and PL/SQL queries to validate DataMart andDatawarehouseBackend Testing.
• Worked heavily on testing various Data warehouse ETL process wif tools includes Informatica, Data Stage, Ab Initio, SSIS as well as many reports developed used various BI tools includes Business Objects, Congo’s, Micro strategy, OBIEE, SSRS and Crystal Reports.
• Created logs forETLload at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.
• Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skills.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases
• Expert in removing teh Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS
• Developed OLAP cubes using SSAS (SQL Server Analysis Services).and calculate teh metrics that were revealed in teh functional analysis.
• Experience DTS and T-SQLstore procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed data interface layer using ASP.NET and C# for data access.
• Excellent communication and interpersonal skills and TEMPhas ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.

TECHNICAL SKILLS:

Databases: SQL server 2000/2005/2008 R2/2012/2014, MS Access, Teradata

Operating Systems: Windows NT/98/ 2000/XP/Vista/2003, MS-DOS, Unix

OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting Service (SSRS), MDX, Business Objects 6.x, crystal reports.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS, ETL Informatica.

Other Tools: Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Microsoft Visio 2000/2003,Altova tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler

Programming languages: C, SQL, PL/SQL, T-SQL, C#, Asp.NET.

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical and Logical Data Modeling

Data Warehousing & BI: SQL Server, Business Intelligence Studio, SSIS, SSAS, Access Manager, SQL Server2000 Analysis Services and SQL Reporting services, DTS, ProClarity, PPS-2007, MOSS

PROFESSIONAL SUMMARY:

Confidential, Oakland, CA

Sr. MS SQL Server BI/SSIS Developer

Responsibilities:

• Designing Logical and Physical Data Model wif Erwin tools.
• Worked wif installing, designing and managing MS SQL Server 2008 R2.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
• Expertise in writing SQL Statements in database to make sure whether thedatais populated inDataMart/DatawarehouseAccording to Business Rules.
• Experience in data loading from Excel to MS SQL Server using BCP and SSIS Services.
• CreatedSSIS2012 Packages to perform filtering operations and to import teh data on daily basis from teh OLTP system, DSR to SQL server.
• DesignedSSISpackages for Member Interfaces and Extracts.
• CreatedSSISPackages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Established ETL design practices for optimization and performance of packages and Parameterized SSIS packages wif teh use of environment variables.
• Effectively involved in all scrum,agileand code review meetings to understand teh business and discuss teh weekly report.
• Used TIDAL scheduler for creating Job groups, scheduling daily and weekly jobs, Email alerts.
• Writing SSIS packages to load data into Facts and confirmed DIM tables to build cubes.
• Involved in various Transformation anddatacleansing activities using various Control flow anddataflow tasks in SSIS packages duringdatamigration.
• Proficient in Data Migration from sources likeTeradata, MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Worked on developing SSIS packages, SSAS cubes and SSRS reports from teh scratch.
• Developed various kinds of reports like crystal, adhoc, drilldown and drill through using SSRS 2012 version.
• Worked wif SQL profiler to improve and enhance theMDXquery execution time as a part of performance tuning process.
• Added and updated teh reports on theTeamFoundationServer (TFS).
• Developed stored procedures, complex queries, triggers and functions by using T-SQL and implemented best practices to maintain optimal performance.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Administering teh MS SQL Server by creating user logins wif appropriate roles, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Created and modified severalUNIXshell Scripts according to teh changing needs of teh project and client requirements.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Experience creating Tableau Dashboards connecting to multiple data sources like Oracle, SQL Server, Teradata and Excel File.
• Used DTS and T-SQLstore procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Worked extensively on Postgres SQL and has converted several Postgres SQL functions to native SQL server stored procedures.

Environment: MS SQL Server 2012/2014, SSAS, Tableau, ETL, Data warehouse, Informatica, SQL Server Reporting Services 2012/2014, SSIS, Windows 7, SSIS, MDX, TFS, T-SQL, MS Office 2013, Power Pivot, Teradata, Unix, Visual studio 2013/2012/2010

Confidential, Atlanta, GA

Sr. MS SQL BI/SSIS/SSRS Developer

Responsibilities:

• Responsible for creating reports based on teh requirements using SSRS 2008 R2/2012. Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Created complicated reports like parameter based reports, graphical reports, excel reports, drill-down chart and tabular report using SSRS2008 R2/2012.
• Worked in Agile Scrum Methodology wif daily stand up meetings and great knowledge in TFS (Team Foundation Server).
• Used ETL to implement Slowly Changing Dimension to maintain historicaldatainDataWarehouse.
• Tested all teh ETL processes developed for fetchingdatafrom OLTP systems to teh target Market Datawarehouseusing complex SQL queries.
• Used Multi-dimensional expressions (MDX) to present teh date asked by teh user, to simultaneously query on different dimensions.
• Filed, maintained and debugged tidal jobs and tickets as part of troubleshooting.
• Slowly Changing Dimension Transformation used for updating changes in teh dim tables
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Worked on OLAPDatawarehouse, Model, Design, and Implementation.
• DevelopedUnixShell Scripts to automate backend jobs, load data into teh database.
• Created schemas, keys and indexes considering teh granularity of teh data.
• Experience in designing and development of Tableau visualization solutions and Created Technical document on top of BRI document for teh business users.
• Prepared UNIX scripts to run teh Informatica ETL jobs from command line.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.0.
• Experience in creating SSIS packages using different type’s task and wif Error Handling.
• Performance tuning and optimization of procedures and queries.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling teh SSIS packages and Jobs.
• Worked closely wif end users in designing and creating teh Data warehouse for management group using SSIS and Erwin.
• Designed, modified and troubleshoot SSIS packages.
• Utilized SSIS Checkpoint, Loading Dimension wif teh SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Created logical and physical database design, data structures and maintained it by using Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Transformed complex business logic into Database design and develop Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Worked on Team Foundation Server (TFS) to work, maintain track of report and also all documentation.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Environment: MS SQL Server 2008R2/2012, Management Studio(SSMS), ETL, Erwin, PowerPivot, Oracle11g/10g/9i/8i, Crystal Reports9.0, MDX, TFS, Tableau, Data Warehouse, Data Modeling, OLAP, Data warehousing, T-SQL, DB2, SSAS, SSIS, SSRS 2008 R2/2012.

Confidential, Detroit, MI

SQL BI/SSIS Developer

Responsibilities:

• Involved in designing, reviewing, and creating Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Optimized Query Performance, Session Performance and Reliability.
• Created DTS/SSIS packages for teh extracting, transforming and loading teh data.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Designed Extract Transform Load (ETL) process to populate teh data warehouse using SSIS.
• Developed SSIS solution for developing a fully-fledged data warehouse solution.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, datamart databases.
• Involved in Analyzing, designing, building &, testing of OLAP cubes wif SSAS 2008/2012/2013 Visual Studio and in adding calculations usingMDX.
• DesignedSSISpackages for Member Interfaces and Extracts.
• Developed and deployed data transfers packages usingSSIS, also maintained teh jobs running on Servers.
• Used variousSSIStransformations for loading teh data into teh Middle Office tables.
• Created Tableau worksheet which involves Schema Import, Implementing teh business logic by customization.
• Modified teh ExistingSSISPackages and added more audits and alerts in case of package failure.
• Generated Reports using Expressions and Functions for teh reports using SSRS 2008.
• Generated Snapshot, Drill Down, and parameterized reports using SSRS.
• Performed Data Modelling and Developed logical and physical model using Erwin and implementing them to SQL server.
• Wrote custom T-SQL stored procedures andtriggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• Performed partitioning of cubes as well as cube optimization in order to increase teh performance of cubes.
• Migrated DTS packages from SQL Server 2000 to 2005 and scheduled their execution time.

Environment: MS SQL Server 2008R2/2012, Management Studio(SSMS), ETL, Erwin, PowerPivot, Oracle11g/10g/9i/8i, Crystal Reports9.0, MDX, Data Modeling, OLAP, Data warehousing, T-SQL, DB2, SSAS, SSIS, SSRS 2008 R2/2012.

Confidential, Wilmington, DE

SQL Server Developer

Responsibilities:

• Selected teh dimensions required based on teh analysis requirements, Created teh new dimensions, Shared dimensions, and time dimensions.
• Analyzed teh requirements and selected teh appropriate fact tables/created fact tables.
• Performed tune to optimize SQL, TSQL queries using SQL profiler and query analyzer.
• Wrote T-SQL code for creating cursor and handling teh data validations.
• Created reports wif Analysis Services Cube as teh data source using SQL Server 2005/2008 Reporting Services.
• Involved indatamigrationand used SSIS to import and exportdatainto tables using SQL Server 2005/2008, creating tables, views and Store Procedures using SQL server.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Extracted teh data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into teh target DW usingSSIS(SQL Server 2008).
• Loaded Data to teh Interface tables from multiple data sources such as MS Access, Oracle, Text files and Excel Spreadsheets using SSIS.
• DesignedSSISPackages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Designed and implemented stored procedures and triggers for automating tasks.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for teh reports.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified teh Data Source and defined them to build teh Data Source Views.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for teh project.
• Trouble shoot and minimized production down issues.
• Designed and implemented stored procedures and triggers for automating tasks.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Crystal Reports, ERWIN, XML, VB.NET, MS PowerPoint, T-SQL, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential

SQL Server/SSRS Developer

Responsibilities:

• Gatheird requirements about teh project which was used to create teh SSIS 2008 packages.
• Wide knowledge of ETL architecture, data schemas and SSIS packages
• Identified teh data sources and created source to target mapping documents to be used by teh packages in SQL Server Integration Services (SSIS).
• Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
• Use ETL to implement teh slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Used various transformations in teh ETL packages while transferring teh data from OLTP source to destination using SSIS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized teh queries for efficient data retrieval by implementing indexes on teh tables.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.

Environment: SQL Server 2008 Enterprise Edition, SSIS, SSRS, T-SQL, Windows NT.

Confidential

SQL Developer

Responsibilities:

• Involved in ER diagrams and mapping teh data into database objects.
• Design of teh Database and teh Tables.
• Build table relationships and wrote Stored Procedure's to clean teh existing data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Involved in Job scheduling and alerts.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Designed and implemented user log in and security.
• Involved in requirement gathering, analysis, design, development, change management, deployment and User Training.

Environment: SQL Server 2005 Enterprise Edition, .NET Framework-SQL, SQL Server 2005, SSIS 2005, SSRS, SSAS, Windows 2003 Advance Server, MS Excel, MS Access, Visual Studio 2005.