SUMMARY

• Sr. SQL server/BI Consultant with over 9 Years of IT Industry Experience in various domains like Finance, HealthCare, Retail, Insurance, Energy etc.
• Expertise in Data warehousing and Business Intelligence Technologies, Specially Implementing with Microsoft SQL Server i.e. MSBI Stack (TSQL, SSIS, SSRS,SSAS 2005/2008/2014 )
• Extensive knowledge of data warehouse methodologies and data modeling
• Strong ability to analyze user requirements
• Skilled Experience in optimizing the queries by creating various clustered, non - clustered indexes and indexed views.
• Implemented end to end application migration and data warehousing projects in OLTP and OLAP environments
• Worked in implementing Waterfall and Agile (SCRUM) Methodologies including Database design, Development, Testing and UAT.
• Proficient in creating objects such as Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) and Complex Queries on Microsoft SQL Server 2014/2008R2/2008/2005
• Possessed excellent skills in Data Modeling to create Star and Snowflake Schemas using Erwin and Visio.
• Upgrade SSIS packages to SSIS 2012, 2014 with Enhancements
• Expert in developing SSIS Packages to Extract, Transform and Load (ETL) data from/to SQL Server, SAP HANA, Mysql, Microsoft CRM, Microsoft Azure Cloud Platform, PostgreSQL, Oracle, Sybase, Microsoft Dynamics AX/GP, FoxPro, Flat Files, Excel, CSV, MS Access and HDInsight Service using SSIS.
• Strong knowledge of Big data, Hadoop, HD Insight, Azure Blob Storage
• Experience in Windows, Web applications using ASP.NET, C#.NET and ADO.NET
• Extensive knowledge in Tuning T-SQL queries to improve the database performance.
• Performed data migration using tools like Data import/export, BULK INSERT and BCP between different heterogeneous systems and SQL Server.
• Experienced in creating Report Models, generating Reports for business analysis and management purposes using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS
• Visualizations and reports and adhoc Data warehouse analysis using Tableau & PowerBI
• Hands on experience on upgrading from Microstrategy 8.0 to 9.0
• Understanding of Different BI platforms such as Qlikview, Tableau, CrystalReports, Sportfire etc.
• Experience in Sql Server DBA tasks, Creating SSRS Reports and SSAS Cubes using MDX.
• Good Knowledge of SSAS tabular(xvelocity) Data Model,PowerPivot.
• Build and deploy SSAS multidimensional cubes using hierarchies,aggregations,KPI’s,calculations using MDX,Translations,data mining,partitions, storage modes
• Good knowledge of Defining, Developing and Deploying Star Schema, Snow flake Schema and Dimensional Data modelling using MS SQL Server 2005 Analysis Services (SSAS) on EDW.
• Strong analytical knowledge with excellent communication and interpersonal skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

TECHNICAL SKILLS

Database: MS SQL Server 2000/2005/2008 R2/2014, DTS2000, MS BI Stack (2005/2008/20012/2014 ), Tableau, Microstrategy, Cognos, MySQL, Analysis Services (SSAS 2008), Oracle 9i/10g/11g-PL/SQL, Reports, D2k Reports and Forms, Oracle Discoverer, Work Flow builder, toad, HP open view, XML Publisher Reports, Oracle Applications E-business suiteR12,Sybase ASE 15.5, Noetix, DB2

Software Applications & Tools: Microsoft Visual Studio, BIDS, TFS, Code collaborator, Clear Case, Oracle SQL Developer, Oracle applications, SAP HR functional, Microsoft Visual Source Safe, HP Project Portfolio Management, HP Quality Centre, Eclipse, MS Office, Microsoft SQL Server Management Studio, Techno Solutions Top Team.

Programming Languages: SQL, MYSQL, PLSQL, TSQL, VB, core Java, C, C++

Web Technologies: HTML, CSS, XML, ASP.NET (2.0)

Modeling & Reporting: Erwin, UML, Microsoft Visio, R2M Case tool

Operating Systems: WINDOWS, UNIX, Linux, DOS

Testing Tools: Winrunner, Load Runner, Quality Center, QTP

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. BI-ETL-DW Analyst

Responsibilities:

• Involved in 3 full life cycle (SDLC) implementations of the projects.
• Involved in Upgradation of existing Packages and reports from BIDS 2008 to Data Tools 2014
• Generated Scripts, packages and reports as per the requirements.
• Modified existing scripts to improve performance.
• Identifying, and documenting ETL Standards and best practices for the development team
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions.
• Used various tools like TFS 2013 and code collaborator for version control, code reviews and peer reviews.
• Worked on Enhancements and Improvements in the existing SSIS packages and SSRS reports.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Provided system analysis, design, development, deployment and Support of BI applications

Environment: SSIS 2008/2014,BIDS,SQL Server 2008R2, SQL Server 2014 T-SQL, VB, C#, XML, AS400, DB2, Team Foundation Server 2014, Code Collaborator.

Confidential, Westborough, MA

Sr. Techno-Functional BI-ETL Analyst (Lead Role)

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle,, Access, and Sql Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, Sql Server Migration Assistant (SSMA) and SSIS packages.
• Worked on Health Data Conversions for NFL (National Football Leagues) and SeaWorld
• Generating on demand reports using eBO reporting using SSRS and adhoc reporting using report builder feature in SSRS.
• Build and deploy SSAS cubes for Claims reporting.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal.
• Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS, SSIS, Mysql and vb.
• Till now Analyzed around 50 Different Hospital/Patient Database Management systems and provided optimized solutions for handling them better.
• Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans.
• Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Performed GAP Analysis on data mappings, and data element transformations.
• Used majority of the transformations, tasks, containers present in SSIS which include Fuzzy grouping, Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development.
• T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions
• Generate experience in converting Actuate reports into SSRS
• Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.
• Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Deployment of SSIS packages and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis.
• Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Conduct Code Walkthroughs, and perform SSIS/SSRS peer reviews.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes in corporation, logins & permissions. Created linked servers to write validation queries against the source and target present on different servers.
• Used Team Foundation Server 2010 to check in code artifacts and Techno solutions Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Created database-staging tables for running the QAS batch for Postal Address Validation.
• Implemented framework for Reference/Lookup data changes, Automation of Applying Database Change Request scripts to the target DB.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB,SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS and SSRS introduction material to the client.
• Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012,BIDS,SQL Server 2008R2, T-SQL,Visual Basic .NET, Vb6, XML, eManager, eBO reporting, Microsoft Project, SVN, Core Java, Microsoft Access, SSRS, Microsoft Excel, QAS

Confidential - Hersheys, PA

Sr. MSBI Developer

Responsibilities:

• Gathered business requirements by interacting with the Business Analysts.
• Installed and Configured SQL Server 2005
• Configured the Window Server for required Service Packs.
• Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic
• Designed and implemented Stored Procedures and Triggers for automating tasks
• Created Indexes and performed Index Tuning using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Compliance Group, Order Flow management (OFO) Group, Network Planning Group, TN Management Group etc.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Integrated ASP.net pages with SQL server Database.
• Designing and building data load procedures using MS SQL Server.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects.
• Documented all the procedures and processes for future references.

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, Windows Server 2003, PVCS, Citrix, Windows XP, Erwin 7.1, MSMS, MS Visual Studio 2005, ASP.net, Xml.

Confidential, Irvine, CA

Microsoft BI Developer

Responsibilities:

• Installed and configured SQL Server 2008, SQL Server Integration Services and SQL Server Reporting Services
• Involved in requirements analysis, development, deployment and unit testing of components.
• Generated Reports for a new RDBMS systems called BARS.
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2008
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSRS Packages.
• Deployment of SSIS packages to the Conversion Server.
• Create and published various parametrized and cascading reports for the finance and HR department
• Developed staging tables to house the data and developed exception/error handlers to prevent issues with data being written to the new DB within SQL SERVER SSIS.
• Used XML Package configurations to allow users to modify the package without using BIDS.
• Designed and deployed reports with Drill Down, Drill Through, and Drop down menu option, Parameterized, Sub-reports and Linked reports.
• Developed SSAS Cubes using MDX for Finance department Database
• Documented important KPIs for Business users for their Analysis.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Involved in optimizing report performance using Report Caching and Snapshots.
• Converted Crystal Reports to SSRS reports.
• Worked with Microstrategy to provide reports to the accounts department.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, VISIO, T-SQL,SSIS 2008.

Confidential

Business Intelligence Consultant

Responsibilities:

• Installed & Configured SQL Server 2000 for Development Purpose
• Migrated certain packages from SQL server 7.0 to SQL server 2000
• Created DTS packages to transfer the data from Oracle to SQL Server 2000
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database.
• Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Created Indexes, Constraints and Rules on database objects.
• Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
• Designed and developed MS SQL Server Stored Procedures using T-SQL statements from scratch.
• Developed Triggers on Views to populate base tables.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Create stored procedures and user defines functions to supports efficient data storage and manipulation.
• Handling database objects with Enterprise Manager
• Provided Technical Documentation for future enhancements.

Environment: MS SQL Server 7.0/2000, T-SQL, Query Analyzer, SQL Profiler, Enterprise Manager, PL SQL, Oracle 8i, Windows Server 2000, MS Visio, PVCS.