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/R 2/2012/2014.
• Experience in SDLC life cycle for Design, Development and Staging phases of the projects with 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 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 2012.
• Expertise in generating reports using SQL Server Reporting Services (SSRS), Crystal Reports and MS Excel Power View.
• Data Visualization expert on technologies like Tableau, Micro Strategy, Spot fire and has gained expertise in these years in creating dashboards, reports, reporting and analytic applications and tools to drive sales and revenue growth
• Designed, developed and maintained MDX queries against SSAS cubes to generate reports.
• Developed Logical and physical data model using Erwin, ER Studio and mapped the data into database objects
• Experience with T-SQL in constructing Tables, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity
• Wrote complex SQL and PL/SQL queries to validate DataMart and Datawarehouse Backend Testing.
• Worked heavily on testing various Data warehouse ETL process with tools includes Informatica, Data Stage, Ab Initio, SSIS as well as many reports developed used various BI tools includes Business Objects, SSRS and Crystal Reports
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS
• Excellent Report creation skills using Microsoft Reporting Services (SSRS) 2008.
• 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 the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Experience DTS and T-SQL store 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 has 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 EXPERIENCE

Confidential

SQL BI (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Designing Logical and Physical Data Model with Erwin tools.
• Worked with installing, designing and managing MS SQL Server 2014.
• 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 the 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.
• CreatedSSIS2014 Packages to perform filtering operations and to import the data on daily basis from the 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 with the use of environment variables.
• Proficient in Data Migration from sources likeTeradata, MS Access, SQL server, Text Files, Excel to SQL server 2005/2008/20012/2014 using SQL Server Integration Services (SSIS).
• Worked on developing SSIS packages, SSAS cubes and SSRS reports from the scratch.
• Developed various kinds of reports like crystal, adhoc, drilldown and drill through using SSRS 2012 version.
• Worked with SQL profiler to improve and enhance theMDXquery execution time as a part of performance tuning process.
• Added and updated the 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 the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created and modified severalUNIXshell Scripts according to the changing needs of the 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 have 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, MDX, MS Office 2013, Power Pivot, Teradata, Unix, Visual studio 2013/2012/2010

Confidential, Round rock, TX

SQL BI Developer

Responsibilities:

• Responsible for creating reports based on the 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 with daily stand up meetings and great knowledge in TFS (Team Foundation Server).
• Used ETL to implement Slowly Changing Dimension to maintain historicaldatainDataWarehouse.
• Tested all the ETL processes developed for fetchingdatafrom OLTP systems to the target Market Datawarehouseusing complex SQL queries.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Used Multi-dimensional expressions (MDX) to present the date asked by the user, to simultaneously query on different dimensions.
• Worked on OLAPDatawarehouse, Model, Design, and Implementation.
• DevelopedUnixShell Scripts to automate backend jobs, load data into the database.
• Created schemas, keys and indexes considering the granularity of the data.
• Experience in designing and development of Tableau visualization solutions and Created Technical document on top of BRI document for the business users.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.0.
• Experience in creating SSIS packages using different type’s task and with Error Handling.
• Performance tuning and optimization of procedures and queries.
• Development of specialized reports using Excel Services such as Power pivot & VBA query.
• Develop Power Pivot and developing and maintaining associated data connections for multiple different types of data sources, advanced formula generation and data visualization.
• Worked on SharePoint 2013 BI features, Power Pivot, Power View Reports. Troubleshooting and debugging the issues.
• Installed and configured Power Pivot and Power View.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling the SSIS packages and Jobs.
• Worked closely with end users in designing and creating the Data warehouse for management group using SSIS and Erwin.
• Designed, modified and troubleshoot SSIS packages.
• Utilized SSIS Checkpoint, Loading Dimension with the 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, T-SQL Scripting for complex business logic.
• Transformed complex business logic into Database design and develop Stored Procedures, User Defined Functions, Views, T-SQL 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.

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

Confidential, Long Beach, CA

SQL BI (SSIS/SSRS/SSAS) 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 the extracting, transforming and loading the 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 the 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 with SSAS 2008/2012 Visual Studio and in adding calculations usingMDX.
• Designed SSIS packages for Member Interfaces and Extracts.
• Developed and deployed data transfers packages usingSSIS, also maintained the jobs running on Servers.
• Used variousSSIStransformations for loading the data into the Middle Office tables.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Generated Reports using Expressions and Functions for the 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 the performance of cubes.
• Migrated DTS packages from SQL Server 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 - Atlanta, GA

SQL BI Developer

Responsibilities:

• Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions.
• Analyzed the requirements and selected the 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 the data validations.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services (SSIS) on different Data Sources.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW usingSSIS(SQL Server 2008).
• Loaded Data to the 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 the reports.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data Source and defined them to build the Data Source Views.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the 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, MS Project, MS Access 2000 & Windows Server 2000, Oracle.

Confidential

SQL Server Developer

Responsibilities:

• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Wide knowledge of ETL architecture, data schemas and SSIS packages
• Identified the data sources and created source to target mapping documents to be used by the 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 the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the 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 BI Developer

Responsibilities:

• Involved in ER diagrams and mapping the data into database objects.
• Design of the Database and the Tables.
• Build table relationships and wrote Stored Procedure's to clean the 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.