SUMMARY

• Around 10 years of IT Experience wif Microsoft SQL Server and other databases along wif SSIS/SSRS/SSAS in OLTP and OLAP (Data warehousing) environments.
• Extensive experience in BI Solutions (ETL, Analysis, and Reporting) using SSIS, SSAS, SSRS and T - SQL programming using DDL, DML, DCL commands for various business applications.
• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement Gathering, Design, Development, Implementation, Testingand Development experience.
• Extensively worked logical & physical Data modeling, data architecture design, Normalization and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema).
• Data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Excellent SQL tuning skills and ability to trouble shooting and recover data failures.
• Highly experienced in whole cycle of SQL server integration services packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Involved in several data quality and Master Data Management (MDM) initiatives using SQL Server Data Quality Services (DQS) and Master Data Services (MDS).
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating hierarchies, partitions, aggregations and perspectives as and when required based on complexity of the cube in SSAS.
• Expert in automating process by creating jobs and error reporting using alerts, SQL mail agent, FTP and SMTP.
• Creating and Managing users, roles and assigning necessary permissions.
• Created Dashboard/Scorecard pages in SharePoint Server/MOSS 2007/Performance point server that use different types of web parts and excel services for reports.
• Co-ordinated testing performed by offshore outsourcing agencies.
• Working noledge of SQL Server on AWS (Amazon Web Service).
• Used Mongo DB BI Connector to read data from Mongo DB
• Working noledge of Peoplesoft Payroll.
• Experience working on Power BI (Power Pivot, Power Query, Power View, Power BI).

TECHNICAL SKILLS

• T-SQL
• PL/SQL
• MS SQL Server
• SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Business Intelligence Development Studio (BIDS)
• ETL
• MS Excel
• Team Foundation Server
• Windows Server
• VBScript
• Cognos.

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr BI Developer

Responsibilities:

• Interfaced wif business analyst to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.
• Used Power BI Power query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load data.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLE DB Sources.
• Scheduling and Maintaining SSIS Packages and batch jobs thru SQL Server Agent on a day to day basis.
• Used VB.Net/C# Code in SSIS Script task for sending dynamic email attachments wif customized logging information.
• Responsible for fixing data issues occurred in production.
• Generated multiple reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2012) which consist of report Criteria in various reports to minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Developing OLAP cubes by identifying tables (fact and dimension), data source views, attributes and dimension members using SQL Server Analysis Services (SSAS)
• Developed many MDX queries for creating measures that fits business logic
• Worked on Key Performance Indicators (KPIs), design of Star schema and snowflake schema in Analysis Services (SSAS)
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, XML etc.
• Deployed SSRS reports into a reporting server and implemented security measures at report server by implementing authentication and authorization methods.
• Experience Migrating HR data from Peoplesoft.
• Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.

Confidential, New York

Sr SQL BI Developer

Responsibilities:

• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables wif incremental load.
• Reviewed logical and physical data models for new requirements after discussion wif Team and application users as per agile methodology.
• Applied various data transformations like Aggregate, Sort, Multicasting, Conditional Split etc.
• Experienced in using fuzzy lookup, derived column and slowly changing Dimensions (SCD) to clean data, improve SSIS package performance and error-trapping using logging and event handler.
• Worked on Master data and reference data management system.
• Performed data profiling to identify and report errors in data and suggested mechanisms to handle Bad data.
• Implemented the elements of T-SQL like stored procedure to store and update the information regarding customers into one centralized SQL database.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the depending on the criteria into the tables.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Created different type of SSRS reports including Cross-tab, Conditional and OLAP.
• Generated Sub-reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Used Expressions, Functions and wrote custom code using C# for the dynamic sorting, dynamic visibility and dynamic columns using SSRS.
• Developed OLAP cubes using SSAS and calculated the metrics that were revealed in the functional analysis
• Involved in Dimensional modeling by identifying the fact and dimension tables and design star/snow flake schemas for the Sql Server Analysis services.
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Code Business logic in C# (SSIS Script Task).
• Created adhoc reports to users in Tableau by connecting various data sources.
• Build and publish Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Used Sql server on AWS (Amazon Web Service) as source to generate SSRS Reports.
• Involved in to use TFS and Subversion (SVN) for change control.
• Utilized Jira as defect tracking tool on the project.

Confidential, Greater Philadelphia, PA

BI Developer

Responsibilities:

• Supported Enterprise BI Development and support for various Business Divisions at PNC interfacing Microsoft CRM Applications.
• Developed SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Used different control flow tasks such as Sequence Container, For Each Loop (File Enumerator, ADO Enumerator), For Loop, Execute SQL Task, Execute Process task, Script task and FTP task.
• Implemented different transformations like Look up, Dynamic Lookup through variable, conditional split, derived columns, multicast, union all, sort, merge, pivot transformation.
• Experience wif SSIS performance tuning using counters, event handling, re-running of failed SSIS packages using checkpoints and scripting wif Active-X and VB.Net in SSIS.
• Scheduled SSIS packages as jobs to run automatically to Process the cube, load data etc.
• Generated multiple Enterprise reports from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features.
• Designed various SSRS reports using different reporting features such as group by, drilldowns, drill through etc.
• Used various types of report layout options like charts (bars, lines, pie etc.), images, sub-reports, and hyperlinks to make them more attractive and understandable.
• Involved in Administration of SQL server reporting services (SSRS).
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases.
• Involved in building dimensional cubes wif SSAS and querying the data wif MDX script.
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries wif MDX, Data Mining Models, and developing reports.
• Involved in mapping customer requirements to Microsoft Dynamics CRM.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).

Confidential, Columbus, Ohio

SQL BI Consultant

Responsibilities:

• Designed ETL packages dealing wif different data sources (SQL Server, Flat files etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services.
• Developed new mappings using SSIS Look Up/Aggregation Transformations to match the needs of the business case.
• Used Framework Manager to build metadata model, which could be used by Report Developers in the group.
• Created, published, and modified several packages in Framework Manager according to the business needs.
• Developed Standard Templates, which laid a foundation for all reporting needs.
• Analyzed the requirements and specifications to create the Reports, Quarterly Package and Dashboards.
• Developed advanced reports using Report Studio and Ad-hoc reports using Query Studio.
• Created reports, Drill through Reports and Cross Tab reports using Cognos Report Studio.
• Resolved level 3 Support tickets for assigned applications.
• Worked wif TFS (Team Foundation Server) to keep track of all changes made in the project.
• Used Performance Point Server to create interactive reports wif an ability to drill down into details.
• Experience in Planning and Monitoring reports in Performance Point Server.

Confidential, St Louis, MO

BI Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube and load data.
• Involved in development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions wif the cube wizard and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Worked on large data warehouse Analysis services servers and developed reports and KPIs using SSRS, ProClarity.
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• While developing reports from Cubes also used the KPI’s for decision making, also implemented Cube Partitions and debugged data connections, data sources and Data Source Views.

Confidential, Mason, OH

Sr ETL Developer

Responsibilities:

• Worked wif various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers, Functions
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2005) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamics reports and other features of Reporting service.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2005/2008.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Created Data-data packages in SSIS as part of the automating the process for billing method.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Experience in configuring wif checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Published reports on to the SharePoint and created Web parts in Share-point to show various reports generated from Excel and SSRS in one web part page
• Created forms on share-point to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.

Confidential, Des Moines, Iowa

SQL Developer

Responsibilities:

• Involved in Designing architecture of the warehouse, Logical & Physical Data modeling, data Dictionary mappings
• Involved in writing various DB Objects like User defined functions, Views, instead of triggers, Usage of Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by Performing different kinds of transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups,Derived Columns, Merge Join, Conditional Split, Data Conversion wif Multiple Data Flow tasks
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third-party Tools
• Involved in Monitoring and troubleshooting complex packages by using Data Viewers Grids, Debugging and maintenance of ETL packages and ETL optimization using SQL Server best practices
• Configured, Installed, Administered Reporting Services 2005
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through/Drilldown Reports and Created Large Number of Report Models for users to create their own reports.
• Deployed the solutions on Web Server, Involved in Creating User Security and Roles in Reporting Services at both Parent Level and Report Level
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions
• Worked on Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables
• Involved in optimization of Data Models using Kimball Methodology
• DevelopedOLAP Cubes by using SQL Analysis Services (SSAS)and defined Data Sources, Data Source Views, Dimensions, Measures, Hierarchies, Attributes, Calculations, KPI’s, Perspectives and Roles.
• Extensively involved in theSSAS storagemethods (MOLAP, HOLAP, and ROLAP), partitions, andaggregations, calculation of queries, Data Mining Models, developing reports using MDX and SQL.