SUMMARY

• Around 8 years of IT experience in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.
• Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
• Strong working experience on SQL 2000/2005/2008 R2/2012/2014 including DTS, Performance tuning, Reporting, designing logical/physical databases and Troubleshooting.
• Experienced in SQL Server 2005/2008/2012/2014 RDBMS database development including T - SQL programming.
• Experience in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Solid knowledge of Power BI Desktop & report performance optimization.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), Google Analytics, SQL Server Reporting Services (SSRS).
• Experience in developing reports on SSRS on SQL Server (2005/2008/2008 R2/2012/2014). Sound Experience and understanding of SSIS & DWH Architecture.
• Experience in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data Warehouse Environment.
• Knowledge and understanding of SSAS, OLAP and OLTP cube.
• Good experience in writing complex queries, stored procedures, Analytics, user defined functions, indexed views, CTE'S (common table expressions) and Triggers using SQL Programming
• Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012/2014 and Transformation.
• Experience in Designing Dimensions, Data Aggregation and Storage design of Cubes, measures with Star schema and Snow-flake schemas.
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports and Report Models and ad-hoc reports, Crystal Reports using SSRS.
• Experience in defining Queries for generating drill down and drill through reports in SSRS 2008.
• Developed and maintained multiplee Power BI dashboards/reports and content pack.
• Responsible for buildingg Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created Power BI Visualizations and Dashboards as per the requirements.
• Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2008/2008 R 2/2005/2000/2012/2014.
• Able to work with a team or individually with excellent communication skills, and ability to meet deadlines in a fast-paced work environment.

TECHNICAL SKILLS

Programming Languages: SQL, PL\SQL (Triggers, Stored Procedures and Functions, Packages), C, C++, .NET, MATLAB.

ETL Tools: Ab Initio & SSIS, Data Profiler, EME, Data Stage SQL Server, DTS/Integration Services, SQL*Loader, Informatica Power Center /Power Mart, Power designer

Reporting Tools: SQL Server Reporting Service(SSRS), Power BI, Share point 2007.

Analysis/ Modeling Tools: Erwin, MS VisioUtilities SQL*Plus, SQL*Loader, Import/Export, Performance Tuning

Scripting: UNIX Scripting (SH, CSH, KSH, BASH)

Operating System: Mainframes, Windows Vista, UNIX, Sun Solaris, AIX

Web Development Tools: HTML, DHTML, XML, PHP, Java Script, Dreamweaver.

Tools: XML, TOAD, MS Office Tools.

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

MSBI/Power BI Developer

Responsibilities:

• Extensively involved in designing the SSRS reports and SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Implemented advanced features in SSAS including translation, role based security, custom actions, SSRS actions & partitions
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI's in SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed Dimensional Modeling using SSAS cubes for End-User.
• Migrated and translate legacy reports into Power BI from SSRS environment.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets for Power BI
• Involved in writing SQL joins, sub queries, Google Analytics tracing and performance tuning for better running of queries.
• Pulling the data from T-SQL stored procedure to make the parameterized report.
• Created multiple data visualization solution for initiall Power BI environment business preview.
• Extracted data from On-Premises and SaaS (Software as a Service) into Power BI desktop.
• Published reports and dashboards to the Power BI service through the Office 365 integration.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Indexes, Analytics, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Performed most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Experience in creating complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008/2012 and Transformation.

Environment: SQL Server 2008/2005 Enterprise Edition, Google Analytics, SQL BI Suite (SSAS, SSIS, SSRS), Power BI, VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MOSS 2007, MS Project, MS Access 2008 & Windows Server 2008, Oracle.

Confidential, Dayton, OH

SQL/ BI Developer

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling
• Responsible for identify and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Responsible for building Power BI Dashboards using Tabular Model. Design and model data set with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Performed the Power BI report validation against the databases.
• Involved in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Involved in migration of SQL Server /2012.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created tables, matrix, and chart reports as required and deploy those reports into Power BI service.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Designed and developed matrix and tabular reports with drill down, Google Analytics, drill through and drop down menu and used gauge reports with KPI's in SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.

Environment: SQL Server 2005/2008 R2/2012, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, Power BI, MDX, ASP.NET, C#, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, MS Visio.

Confidential, Richmond, VA

SQL/ BI Developer/Data Analyst

Responsibilities:

• Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
• Developed highly scalable report automation system utilizing SSIS, T/SQL, stored procedure, cursor, Enterprise Manager, Query Analyzer.
• Investigated various platform, languages, and database designing tools and suggested the best solution to upper management considering reusability, scalability and maintainability. Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Designed SSIS packages to extract, transform and load data to SQL tables from txt and csv file received from various clients.
• Used to develop the reports by using SSRS and Power Pivot.
• Developed several scripts to synchronize stored procedures, SSIS to log messages and outputs.
• Created SSIS tasks to email output and log messages using ActiveX script.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• Created standard tables and mapped columns from various client tables.
• Designed a master SSIS to execute all synchronized stored procedures, other SSIS.
• Gathered various business logics and developed numerous reusable stored procedures compatible for all clients.
• Created SSIS packages to integrated window application to DTS and set control file path and timeout value
• Generated Tabular reports, Cross Tabs, Drill down, Drill Through, Cascading and Parameterized Cascading Reports, Sub Reports, Summary Reports, Charts, Functions and Maps using SSRS, Tableau reports.
• Created SSIS package to re-import data to SQL table from output file and mapped column appropriately.
• Analyzed output files, applied necessary business logics and created stored procedures accordingly.
• Develop script to set parameters for various clients and schedule SSIS appropriately.
• Participated in data mining and validation process.
• Effectively hosted several web meeting and showed many design and code review demonstrations.
• Completed many Unit and Integration, functional and acceptance testing.

Environment: SQL Server 2005/2008 R2/2012, Query Analyzer, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, MDX, ASP.NET, C#.NET, Agile, Visual Studio 2005/2008, XML, Crystal Reports, ER-Win, Enterprise Manager, Visual Source Safe, Excel, SharePoint, Unix ODBC, MS Visio 2008.

Confidential

Data Analyst/Business Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys and observing from account managers and conducted controlled brain-storming sessions with project focus groups and documented them in the Business requirement Document.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Sequence Diagrams using Rose.
• Extensively used SQL for accessing and manipulating database systems
• Create various Data Mapping Repository documents as part of Metadata services (EMR).
• Involved in the Data Movement between Systems and validated the Business Requirements.
• Involved in business process modeling using UML
• Verified the correlation between the UML diagrams and developed detailed diagrams
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Done SQL Server configuration database size estimation, database creation logins & user’s creation, granting object level permission, estimation of indexes on tables.
• Created a logical design of the central relational database using Erwin4.x data transformations in both normalized and de-normalized data environments
• Involved in data manipulation using stored procedures and Integration Services.
• Worked on query optimization, stored procedures, views, and triggers.
• Assisted in OLAP and Data Warehouse environment when assigned.
• Maintained security and data integrity of the database.
• Helped to develop test strategies, test cases, test plans, defect reports, Traceability Matrices and test environments and managed the testing process, bug reporting and analysis of test results.
• Developed several forms & reports using Crystal Reports.

Environment: Windows Server 2003, MS SQL 2005/08, UNIX, Erwin4.x, Crystal Reports8