BACKGROUND SUMMARY:

• Proficient in Multi Dimensional Data Analysis, Data Mining and Dimensional Modeling, Data Mapping, Identification & Documentation, Data Extraction, Transformation & Load Process from Heterogeneous Data Sources, Data Verification, Data Profiling/Standardization, Data Cleansing/Scrubbing, Integration, Data Import & Export.
• Extensive Experience in building Microsoft (MSBI) Business Intelligence, Decision Support Systems (DSS) & Corporate Performance Management Solutions (CPMS) including Dashboards, Score Cards, Query & Analysis reports & KPI’s using SharePoint 2013/2010, MS SQL Server Analysis Services, MS SQL Server Integration Services, MS SQL Server Reporting Services, IBM's COGNOS, TERADATA, BigData, Informatica.
• Proficient with MS SQL Server 2012/2008/2005 Analysis Services such as building Multi - Dimensional cubes, Dimensions, Fact tables, Hierarchies, levels, roles, performed drill-up, drill-down, drill-through and applying cube security. Performed Multidimensional Expression (MDX) Queries to extract data from cubes.
• Proficient with MS SQL Server 2012/2008/2005 Integration Services, Extensively used ETL methodologies for supporting Data Extraction, Transformations and Loading processing, in a corporate-wide-ETL Solution. Used various Transformations such as Execute SSIS/DTS Package Task, Aggregate, Lookup, Conditional Split, Slowly Changing Dimension, and Import/Export wizard.
• Proficient with MS SQL Server 2012/2008/2005 Reporting Services such as building Tabular reports, Matrix reports, Chart reports, Parametric reports, Linked reports using Report Designer/Report Builder.
• Proficient in Ralph Kimball’s ETL DW Dimensional Modeling Methodology and Performance Tuning of Data Warehouses including the creation of Materialized Views and types of Partitions.
• Generated Relational Data Modeling, ER Diagrams (Forward & Reverse engineering), Dimensional Modeling, OLAP multi dimensional Cube design & analysis, defined Slowly Changing Dimensions (SCD - (Type1, Type2, and Type3), Surrogate key, STAR, Extended STAR, Galaxy, and SNOWFLAKE Schema’s.
• Extensively used multiple flavors of SQL including MS SQL, T-SQL, MySQL, and Oracle PL/SQL. Used advanced concepts of SQL including Joins, Sub Queries, Set Operators, Tables, Views, Indexes, T-SQL & PL/SQL Stored Procedures, Triggers, Functions, Packages, Cursors, Exceptions and Dynamic SQL.
• Extensively used ETL methodologies for supporting Data Extraction, Transformations & Loading processing, in corporate-wide-ETL Solutions using Informatica PowerCenter & Microsoft SQL Server Integration Services.
• Excellent knowledge in Financial, Banking, Financial market, Investment Banking, Financial Statements, Derivatives, Interest rate modeling, and Discount Cash Flow (DCF) Analysis.
• Strong experience in using Business Process Models (context, data flow diagrams) and Used ERwin tool for Entity Relationship diagrams as precursors to workflow Development, re-engineering, functionality enhancements, migration to new technology and value-addition of existing business solutions.
• Good Knowledge of Functional and Geographic Flowcharts, Check Sheets, Histograms, Run Charts, Control Charts, Cause and Effect diagrams, Inter-relationships diagrams, Scatter diagrams, Pivot table.
• Flexible, enthusiastic and project oriented team player with solid Communication and Leadership skills to develop creative solution for challenging client needs.
• Experience in using version control tools such as Visual Source Safe (VSS) and Team Foundation Server (TFS), TortoiseSVN, CruiseControl for continues integration.
• Great Experience with custom SharePoint collections, lists, users, views and document libraries.

TOOLS & TECHNOLOGIES:

OLAP & BI Tools: MS SQL Server Analysis Services ( 2012/2008/2005 ), MS SQL Server Reporting Services ( 2012/2008/2005 ), COGNOS 10.0/8.0/7.x, Framework Metadata Manager, PowerPlay Transformer, COGNOS Query, Query Studio, Analysis Studio, Report Studio, PerformancePoint Service, SharePoint 2013/2010/2007 , Dundas 5.0, Tableau 8.1

Reporting Tools: MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), MDX, XMLA, MS Excel PowerPivot, PowerView

ETL DW Tools: MS SQL Server Integration Services (SSIS) 2012/2008R2/2005, Informatica PowerCenter 9.1/8.6/8.0/7.0

Methodologies: Ralph Kimball’s DW Dimensional Modeling, STAR, Extended STAR, Galaxy, SnowFlake Schema Modeling, OOAD

Data Process and Modeling Tools: ERwin 9/7/4/3.5, ER/Studio, Rational Requisite Pro 2001, MS-VISIO 2003/2002

Databases &: BigData Tools MS SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 11g/10g/9i/8i/8.0, MS Access 10/07/03, MySQL, TERADATA, NoSQL, Mongo Database, HADOOP+HDFS

Programming & Scripting Lang: T-SQL, PL/SQL, MDX, XML, XMLA, HTML, C, C++, C#.NET, Visual Studio.NET, VB.Net, VB Script, Java Script, J Script, Basic Unix Commands

Development & Tuning Tools: MS SSMS, TOAD 8.5/7.6, SQL Analyzer, Query Analyzer, SQL Server Profiler

Office Tools: MS Project, Smart Draw, MS Excel, MS Word, MS PowerPoint, MS Outlook, MS Lync, Adobe Acrobat, Adobe Photoshop, Macromedia Flash

Operating Systems: Windows 2003/2000/NT/XP, Vista, Windows 7, HP Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Developer, Phoenix, AZ

Responsibilities:

• Applied business requirements and performed detailed data analysis, design the layout for the data integration, and determined the structure, content, and quality of the data through examination of the source systems & data sample and used the Data Profiling Task.
• Created SSIS Packages for extracting data from different sources such as SQL Server, FTP server and other third party tools, such as Trumba, in the form of Tables, Views, FLAT files, XML files and CSV files; loaded those data into the SQL Server tables and then to the Salesforce Objects, and also to handle validating data in staging tables. The package extracts reject records in those tables if the records are in invalid formats and data types; generate error messages and send them to the user through e-mails.
• Used different data transformation methods. Used variables and parameters in packages for dynamically driven data extracting and loading. Used complex SSIS expressions.
• Wrote complex T-SQL Queries and created Stored Procedures for retrieval of the data and analysis of the data. Created complex user defined Functions, Indexes, Tables, Views, SQL Joins and T-SQL codes to implement business rules.
• Optimized the performance of various SQL & TSQL scripts, Stored procedures & Triggers, created various clustered & non-clustered indexes & rewriting the existing queries and SQL Profiler for optimizing indexes & query performances.
• Estimated work effort with task breakdown, and developed the coding approach and verified approaches and estimated with supervisor and team members.
• Applied the best practices in SSIS Packages such as Naming conventions, Performance tuning, and Error Handling. Performed documentation of standards, best practices, and ETL procedures.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables on Salesforce database after applying different transformations. Then Loaded to the Salesforce.com and performed overall design of the solution.
• Produced JSON Documents for application tracking tools from SQL Server queries using T-SQL for enrollment data. Generated source files and produced flat file layout that fit to the mainframe system.
• Converted SAS queries into T-SQL queries and created views to give access to the SAS group.
• Used the Salesforce Object Query Language (SOQL) to retrieve data from the Salesforce.com and generated mapping table for lead data on SQL server. Created custom fields in the Salesforce.com sandbox and used them to integrate with the SQL server tables; generated testing files. Participated with Salesforce admin and wrote complex T-SQL queries to meet the requirements before loading to the Salesforce.com

Environment: MS SQL Server 2012/2008R2, SSMS, SQL, TSQL, Team Foundation Server, MS SQL Server Integration Services 2012/2008R2/2005, ActiveBatch, C#, MS Lync, MS Outlook, MS Excel, MS Word, MS PowerPoint, MS SQL Server Reporting Services, PerformancePoint Service, SharePoint 2013/2010, TASK Factory, KingswaySoft, Salesforce

Confidential

BI Application Developer, Chandler, AZ

Responsibilities:

• Translated business requirements into data warehouse architectural design. Performed detailed data analysis, i.e. determined the structure, content, and quality of the data through examination of the source systems and data sample.
• Built ETL processes to convert Operational transactional data from various sources into dimensions and fact tables. Implemented Ralph Kimball’s Dimensional Modeling Methodology for designing an OLAP cube.
• Developed Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTE), Merge statements, Tables, Views, Indexes, Synonyms, and other MS TSQL codes used for SSIS Packages, SSRS Reports, and Database: for both staging and Data Marts; Implemented different types of constraints on tables for consistency.
• Created, modified and deleted custom SharePoint collections, lists, users, views and document libraries.
• Created SSIS Packages for extracting data from different sources such as FTP server, SharePoint lists, Operational databases and other confirmed databases; loaded those data into the Data Marts, and also to handle validating data in staging tables. The package extracts reject records in those tables if the records are in invalid formats and data types; generate error messages and send them to the user through e-mails.
• Performed Incremental Loading and Implemented Slowly Changing Dimensions (Type -2) to maintain historical data by using MERGE statements, and wrote stored procedures that drop and recreate foreign Key constraints before loading data in the Data Mart.
• Designed Master package that executes packages to extract files from the sources; to load data from the staging to the Data Mart, and to process the cubes. Created various data transformation methods, variables & parameters in packages for dynamically driven data extracting & loading which includes SSIS expressions.
• Created various SSIS configuration settings including Environment Variables, SQL Server and XML configuration files. Used event handler to handle errors. Used BIxpress tool for package configuration and package deployment.
• Designed Powerful Dashboards for key business drivers such as service request volume, past-due requests, Service request customer satisfaction, Quality audit for each sites, and call center Performances, etc using the PerformancePoint Dashboard designer on SharePoint 2010.
• Created and Modified an OLAP cubes. Added attributes, new dimensions etc. Created MDX scripts for reports using Analysis Services cubes as data sources. Integrated SSRS reports and Analytic Charts with SharePoint and PerformancePoint Dashboards. Added calculated members and named sets by using MDX queries. Analyzed the performance of the cubes by partitioning it and creating Perspective Cubes.
• Built dimensional model & assigned hierarchy, attribute relationship to the various dimensions and measures defined using SSAS.
• Designed and developed advanced reports such as Matrix reports, drill down, drill through, chart reports, multi parameterized reports by using Reporting Services Expressions, Global Variables, Conditional formatting, Query parameters, Report parameters as filters, and Actions.
• Used Indicators & applied expressions on the quality audit report to show the performance of each sites and buildings. Used Clustered & Non-Clustered Indexes to enhance and advance higher querying performance for tables with huge amount of records. Used SQL Server Profiler to identify the performance of running queries. Performed SQL queries extensively to test the Data Warehouse.

Environment: MS SQL Server 2012/2008R2, SSMS, SQL, TSQL, TortoiseSVN, CruiseControl, MS SQL Server Integration Services, MS-SQL Server Analysis Services, MDX, MS SQL Server Reporting Services, PerformancePoint Service, SharePoint 2013/2010, BIxpress

Confidential

BI Report Developer, Social Adepts, AZ

Responsibilities:

• Developed Business Process Flows and created ER diagrams using ERwin for Social Media Management software for the development team to understand the system.
• Designed a relational database using ERwin data modeling tool. Created logical and physical data models. Defined the relationships between primary and foreign keys in tables.
• Integrated Database maintenance jobs to perform full and transaction log backups and scheduled them with the SQL Server Agent Job Scheduler. Performed backup/restore, database objects such as Tables, Views, Indexes, Stored Procedures, Triggers, and Constraints.
• Created rollback and commit transactions in SQL queries, used collections, inserted various kinds of constraints and indexes to enhance the queries.
• Improved the performance of queries by introducing Clustered and Non-Clustered indexes on tables in the data base. Implemented SQL Server Profiler to recognize & tune the long running queries.
• Wrote complex SQL Queries & created Stored Procedures for data retrieval & analysis. Created complex Triggers, Functions, Indexes, Tables, Views, SQL Joins & T-SQL codes to implement business rules.
• Used SSAS for identifying key dimensions, key measures and assigned Hierarchy, Attribute relationship to the various dimensions and measures to build dimensional models.
• Generated & Enhanced MDX queries and developed Social Media reputation reports such as dynamically driven cascade parameterized reports, sub reports, drill through reports using SSRS. Created scorecards, KPIs and dashboards, analytical charts & reports on PerformancePoint Service.
• Developed Dynamic SQL queries in T-SQL using sp executesql to construct SQL statement at the run time. Created graphical representation of reports such as Bar charts, Pie charts as per End User requirements
• Used different SSRS features such as grouping, sorting, and reports parameters to build sophisticated reports. Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports from OLAP data sources using SQL Server Reporting Services tool.
• Dimensional Modeling was done using SSAS where cubes were built containing Facts, Measures and dimensions these cubes were generated using Data Source Views, build, deploy and process to be analyzed in the cube browser.
• Built SSAS cubes, created new dimensions & measure groups, defined and edited attributes relationships, and SSAS actions. Created partitions and aggregations for better performance. Introduced incremental loading to improve the performance.

Environment: MS SQL Server 2008R2/2008, SSMS, SQL, TSQL, ERwin 4.1, MS SQL Server Integration Services, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MDX, Visual Source Safe, Team Foundation Server, SharePoint Server 2010, MS Excel, ERwin, Face book/Twitter Data API

Confidential

BI Developer, Dorchester, MA

Responsibilities:

• Interacted with Managers and customers to understand new report requirements. Closely worked with managers if the changes were needed to be done to existing reports.
• Designed separate relational data base in SQL server for Line Management section. Applied data integrity rules, defined relationships between Foreign and Primary keys in the tables.
• Wrote stored procedures, SQL queries for reports. Generated Reports using Global Variables, report expressions and Functions.
• Designed complex reports such as dynamically driven parameterized reports, sub reports, drill through reports using SQL Server Reporting Services.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Extensively used MS TSQL codes to create complex Stored Procedures, Functions, Triggers, Dynamic SQL, Cursors, Exceptions, and SQL Codes to create Tables, Views, Indexes, & SQL Joins & Sub Queries.
• Created several SSIS packages for extracting data from databases and loaded those data into tables in SQL server. Used various Transformations such as Lookups, Multicast, Pivots, Derived Columns, Merge joins, Conditional splits etc., when data transformations process was done.
• Created custom Slowly Changing Dimension Transformations logic as alternatives to the existing SCD wizard to improve performance.
• Added SQL Server Providers for logging to capture information about a package at run time, making it easier to troubleshoot package performance and failure. Performed package, container, and task level logging. Created various SSIS configuration settings including SQL Server and XML configuration files. Implemented Check Points to restart execution of failed packages only from the point of failure instead of rerunning the whole package from the start.
• Documented design and development works for report deployment. Uploaded reports into SharePoint site. Created new pages and folders and maintain reports in SharePoint site.
• Created Performance Analysis Dashboard for each staff member at the clinic including Medical Practitioners, Nurses and other Administrative staff was built using SSRS reports and Analytic Charts. They were majorly drawn in line graphs.
• Performed various database tasks such as browsing database objects, creating new objects, viewing dependencies between various database objects.
• Created dimension and fact tables. Created SSIS packages and stored procedures to load those dimension and facts tables. Used different dimension and fact relationships in the cube such as Regular, fact, referenced etc. Created calculated members using MDX queries. Partitioning and un-restricted aggregate usage were used to improve the performance of the cube.
• Partitioned the cube for current year and previous years in order to improve the performance. Initiated incremental loading for better performance.
• Created MDX queries to create custom pivot reports and calculated members in the cube.

Environment: MS SQL Server 2008R2/2008, SSMS, SQL, TSQL, MS SQL Server Integration Services, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MDX, Team Foundation Server (TFS), SharePoint Server

Confidential

BI + ETL developer, Ipswich, MA

Responsibilities:

• Forward and reverse engineered the component of database to implement Logical model of the system using ERwin tool.
• Applied Ralph Kimball’s Dimensional Modeling Methodology to develop various Datamarts. Implemented Star and Snowflake Schema to arrange relational tables.
• Assessed source operational system Data Profiling, and various source file types and logical dependencies. Planned and Mapped source files in Staging Area.
• Established different types of Connection Manager between source data and target positions in Data warehouse. Applied different kinds of Transformations such as Conditional split, Aggregate, Fuzzy Lookup, Lookup, Derived Columns, Multicast, and Merge etc., to operate as specific transforming functionalities.
• Comprehensively applied multiple transformations in Data Flow Tasks to achieve a certain goal of ETL performance. Implemented Slowly Changing Dimensions (SCD Type II) to maintain historical data.
• Transformed the required data from the database of their geographically separate branches to the central data warehouse by using SSIS in Microsoft Business Intelligence development studio (BIDS). Transformation packages are built and configured to run at daily bases.
• Implemented run-time debugging, set breakpoint, watching variables, and monitored the whole process with multiple connected data viewers.
• Created ETL packages and enabled the role to access and run the packages. Further secure the packages by using encryption to protect data within the package.
• Applied the best practices in SSIS Packages such as Naming conventions, Performance tuning, and Error Handling.
• Created Complex Reports with advanced formatting using Report Designer and simple Ad-hoc Reports using Report Builder.
• Built highly formatted dashboard with advanced formatting, including linked reports, parameterized reports, drill through reports, sub reports, bar charts, line charts, and scatter charts.
• Helped in identifying the Key Performance Indicators (KPIs) for all the portfolios such as ROI, IRR etc.
• Participated in optimization & troubleshooting techniques to address performance problems on SQL Server.

Environment: Microsoft SQL server 2008, SSMS, SQL, TSQL, ERwin 4.1, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Excel, Visual Source Safe (VSS), Windows XP

Confidential

BI Report Developer, Boston, MA

Responsibilities:

• Established ER data models to document applications functionality to its objects and schema. Evaluated and enhanced data reliability and consistency.
• Provided application support, design, development and implementation along with testing, enhancements, support and training.
• Provided business intelligence support for the applications and systems.
• Generated Triggers, Stored Procedures, Functions, Tables, Views, Indexes, Joins, and other Constraints on tables for consistency to satisfy various business rules.
• Created various SQL queries by using Joins statements, Sub Queries for combing rows from different tables.
• Performed Unit testing for various modules and grouped them in large aggregates.
• Designed and developed complex reports such as dynamically driven cascade parameterized reports, sub reports, drill through reports by using SQL Server Reporting Services.
• Used PerformancePoint Service to create Scorecards, KPIs and Dashboards, Analytical Charts and Reports; deployed and published on SharePoint Server.
• Built sophisticated reports by adding reports features such as grouping, sorting, & reports parameters.
• Developed Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical reports from OLAP cube data sources using SQL Server Reporting Services. Wrote MDX queries to create datasets for reports.
• Performed various database tasks such as browsing database objects, creating new objects, viewing dependencies between various objects, generating DDL, executing SQL queries, Security Management, monitoring Sessions, and modifying Database Parameters.

Environment: MS SQL Server 2008, SSMS, SQL, TSQL, ERwin 4.0, MS SQL Server Analysis Services, MS SQL Server Reporting Services, MDX, PerformancePoint Service, SharePoint Server, MS Excel, Windows

Confidential

BI Developer, Boston, MA

Responsibilities

• Developed CDMs as the precursor to LDMs to explore domain concepts with project stakeholders and developed Logical data models (LDMs) for entire Enterprise to explore the domain concepts, and their relationships. Physical data models (PDMs) are developed to design the internal schema of a database, depicting the data tables, the data columns of those tables, and the relationships between the tables.
• Designed & developed operational data store (ODS), claims datamart for quicker reporting purposes.
• Created Functional flow diagrams and other High level diagrams for documenting the functionality of separate modules using MS Visio.
• Extensively used all Informatica PowerCenter designer tools including Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed and developed Informatica mappings for data loads and data cleansing. Extensively used Informatica Designer for set of transformations.
• Created mappings for Heterogeneous Sources such as MS SQL Server, MS Access, Excel, and Oracle to load and integrate the instrument level details to warehouse.
• Optimized/Tuned mappings for better performance and efficiency. Involved in performance tuning of SQL Queries, Sources, Targets and Sessions.
• Extensively used most of the Informatica transformations including Lookups, Stored Procedures, Update Strategy and others. Developed sessions using Informatica Workflow Manager.
• Used Workflow Manager for Creating, Validating, Testing and Running the sequential and concurrent Worklets and Sessions and scheduling them to run at specified time before creating Jobs.
• During Implementation phase, Tuned Informatica Mappings for optimum performance. Responsible for the daily loads and handling the rejected data.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including Partitioning, memory tuning and cache management.
• Used Cognos Framework Metadata Manager to define mappings to build the Metadata Models and Packages with customized Query Subjects, Query items and Published packages.
• Utilized Cognos Analysis Studio component for multidimensional data analysis & exploration of huge data sources.
• Used Analysis Studio to explore and analyze data to find answers to business questions and performed with the filtering, calculating, and sorting support for analysis.
• Developed PowerCubes by using Cognos PowerPlay Transformer component and defined OLAP cube structure & data in PowerPlay models.
• Designed and developed Cognos BI reports using Report Studio with data drill-down and slice-and-dice functionality.

Environment: Microsoft SQL Server 2005, SSMS, SQL, TSQL, Agile Methodology, ERwin 4.0, COGNOS 8 Framework Manager, COGNOS 8 Report studio, COGNOS PowerPlay transformer, COGNOS 8 Analysis studio, Oracle, Informatica 7.0, MS Excel, Windows