SUMMARY

• Around 5 years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T - SQL, relational database models, data dictionaries, and data integrity.
• Good noledge in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
• Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in data migration (using tools like Bulk Insert, DTEXEC and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server.
• Expertise in creating SQL server Reports using SSRS 2005/2008.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Create PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drilldown, Top N, Summary and Sub reports and formatting them.
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2005.
• Knowledge and experience in designing, developing and deploying Reports and Dashboards.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Expertise in SQL Server Analysis Services (SSAS) CUBE design, development and deploying.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis Services (SSAS).
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Programming Languages: C, C++, Java

Databases: SQL Server 2008/2005/2000, 7.0, MS Access, Oracle, AS400 and MySQL

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, OLTP

Reporting Tools: SQL Server Reporting Services, MS Excel, SharePoint, Oracle Report Builder, Tableau, Cognos, Qlikview

Application Packages: MS-Front Page, Microsoft Office Suite, SSIS, SSAS, SSRS

Operating System: Windows 10/8/7/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

SQL BI Developer

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Converted data types using Derived Column, Data Conversion Transformation.
• Converted various data files (CSV, XML, COBOL and Legacy Flat Files) based on business logic using Script Task and Script Component.
• Setup the client packages for Accounts, Transactions and Notes based on Templates.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.
• Involved in modifying Teradata stored procedures and performance tuning of variousTeradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Microsoft SQL Server Data Tools for Visual Studio 2012, SQL Server Management Studio 2012, SQL Server Integration Services(SSIS),SQL Server Reporting Services(SSRS),Microsoft Team Foundation Server, Test Explorer, SQL Server Object Explorer, Share Point, T-SQL, MS Excel, XML Schema file using Microsoft Visual Studio.

Confidential, Hatboro, PA

MS SQL Server/SSIS/SSAS Developer

Responsibilities:

• Developed SSIS project for transferring the data.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Conceptualized and Designed Logical and Physical Data Models using ERWIN.
• Analyzed the project database requirements from the user.
• Defined aggregations required and granularity available and required in DW.
• Created various Tables and Views.
• Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for application.
• Transformed the complex business logic and calculations into coding.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• Created the Cubes and Dimensions.
• Defined relationships between Measure groups and Dimensions.
• Defined granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.
• Created calculated fields with MDX code to meet additional measures needs dat are calculated from existing measures.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• Created partitions (employed storage modes and usage based optimization), calculated members, KPI's and perspectives to enhance the cube's utilization. Also used MDX to query them.
• Upgraded Analysis Service 2000 to SSAS 2005.
• Identified and Defined Key Performance Indicators in SSAS 2005.
• Maintained Security Role and Database Users.

Environment: Microsoft SQL Server 2005,Microsoft SQL Server 2008(R2),SQL Server Reporting Services (SSRS),Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS),Share Point, T-SQL, MS Excel, MS Access,ASP.Net, Oracle.

Confidential - Minneapolis, MN

BI Consultant

Responsibilities:

• Involved in gathering the requirements, conducted meetings with clients and documented the requirements and ITIL assessment & implementation of project
• Used SSIS to integrate/extract the data from different OLTP systems into OLAP system for further analysis.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards and conventions
• Interacted with sales and marketing reps to gather business requirements.
• Designed best practices document for ETL and Reporting systems.
• Implemented different types of reports for sales & marketing team to increase the revenue of the website.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Used SSRS to format and schedule interactive reports on daily/weekly & monthly basis.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and involved in writing functions, stored procedures and triggers.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45% increase in performance of numerous modules.
• Involved in performance tuning by adding indexes, optimizing queries, using caching mechanism etc., to improve the site performance.
• Developed Data Mart using Star Schema. Reviewed the Current Data Mart and OLAP Cubes and Proposed Corrections and enhancements.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Using SharePoint environment all the documents and files used to be shared within the organization.
• Used to create Report libraries in new site content.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created Ad-hoc reports, Tabular reports, Drill down and Drill up reports.

Environment: SQL Server 2005 Enterprise Edition, Informatica 7.1.2, Oracle 9i, Microsoft Visual Basic, XML, Windows, IIS 5.0, Microsoft Reporting Service

Confidential

SQL BI Developer

Responsibilities:

• Gatheird functional and Business requirements and wrote technical specifications for building the Global Enterprise Data Warehouse.
• Involved in re-designing of database to create de-normalized reporting schema for better throughput.
• Used DTS, SSIS and Informatica 7.1 to extract the Data from Different Sources like DB2, SAP, Teradata, and Oracle.
• Developed new mappings using transformations like Look Up, Aggregation, Derived Column, Data Conversion etc transformations to match the needs of the business case.
• Created packages for error handling, logging and custom logging to log the error information to SQL Server, Flat files and XML files
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Created DTSX Packages to import and export data from Excel, Access, SQL Server 2005/2000 and Text files.
• Created SSIS Packages using Variables, Expressions and Environment Variables
• Reconcile data for transformation from SQL 2000 to SQL 2005 using SSIS
• Created Production support packages.
• Migrated DTS 2000 packages to SSIS 2005 Packages.
• Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.
• Created MDX queries for different complex measurement and also included KPI for Graphical Analysis.
• Developed Stored Procedures and User defined functions (UDF) to access data from Data Mart.

Environment: SQL Server 2005 Enterprise Edition, Reporting Services, SQL Enterprise Manager, Informatica 7.1, Windows XP, Oracle, MS Access, MS Excel, Windows 2003, HTML.