SUMMARY

• 11+ years of experience in IT. Involved in Development, Implementation, Customization, Conversions, Upgrade and Maintenance of various domains using SQL, SSIS, SSRS, SSAS (MSBI), ETL, Power BI and Tableau.
• Proficient Power BI Developer with an experience of 5 years in design and development of Business Intelligence applications.
• Hands - on with creating solution driven views and dashboards by developing different visualization types in Tableau, QlikView and Power BI.
• Designed, developed and implemented Power BI Dashboards, Scorecards & performance Reports.
• Strong ability to analyze user requirements, Business Requirement Specifications.
• Strong experience with T-SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert in Data Preparation, Data Modeling and Data Blending.
• Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.
• Worked with Different Integration tools like Informatica and Pentaho for ETL
• Extensively worked on performance tuning both at Cognos and database level
• Worked on Designing and Implementation of Business Applications using the Oracle/SQL Server Relational Database Management System (RDBMS).
• Hand on experience in writing calculated columns and measures using MDX and DAX query language
• Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.
• Expertise in Power BI, Power BI Pro, Power BI Mobile
• Created Business Requirement documents (BRD's), such as SRS & FRS, integrated the requirements, and underlying platform functionality.
• Experience in gathering, analyzing and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Expert in creating and developing Power BI Dashboards in to rich look and tested Power BI reports of Database and verified it with the source data. .
• Developed a thorough knowledge and maturity in all the phases of Software Development Life Cycle (SDLC).
• Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation
• Experience in hard coding the crystal commands of Date parameters,(ISNULL(), last full month, month to date etc.), CSTR, Date and String conversions
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Excellent Written and Verbal communication skills and ability to translate Technical Concepts into Business Language and Business Language into Technical Requirements.

TECHNICAL SKILLS

Environment: On Premise, Azure cloud, Google Big Query

RDBMS/ Databases: MS SQL Server, Azure SQL, MySQL, Oracle, MS-Access, Big Data

Languages: SQL, T-SQL, Visual Basic, HTML, MS Team Foundation Server (TFS), Google Big Query, Unix Shell Scripts

Operating Systems: All Windows version from Window XP to Window 10, Azure CLI, Linux

Modeling Tools: Microsoft Visio, E-R studio

Reporting Tools: SQL Server Reporting Services (SSRS), Microsoft Power BI, MS Excel, Google data Studio, Tableau

Integration Services: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Query Editor, Informatica Power center, BIDs

Analysis Service: SQL Server Analysis Services (SSAS)

Methodology: Agile Methodology scrum and Kanban, waterfall, DevOps

Other Tools: Microsoft Office tools, SSPS, Epi-Info, MagPi

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. MSBI/SQL/Power BI Consultant

Responsibilities:

• Developed and published dynamic and complex Visuals, Reports, Dashboard in Power BI Desktop and Power BI services
• Used DAX to create complex measure and calculated columns.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Provided 24/7-production support for ETL and Power BI.
• Created ETL packages with different data sources (SQL Server, oracle, Flat Files, Excel source files, XML files) and tan loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases when performance issues occurred with DBCC (Rebuilding Indexes, Integrity Checks)
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Responsible for debugging applications using the tools provided by the Visual Studio.
• To monitor the production jobs, to troubleshoot for failed packages.
• Developed high level design of ETL Package in MS SQL Server for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file and Text Format Data.

Confidential, Dallas, TX

Sr. Power BI--ETL Consultant

Responsibilities:

• Formulated and documented the physical ETL process design based on business requirements and system specifications, including source to target mappings, transformations, lookups, aggregations and expressions. Involved in designing Databases, Data Marts, E-R model for OLTP and Multi-Dimensional Model for OLAP
• 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 with multiple data flow tasks. Involved in source data analysis, design and creation of data mappings for extraction of bulk data from heterogeneous sources like Oracle and other OLEDB data sources.
• Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Extracted data from various sources like SQL server, Oracle, CSV, Excel, Text, Json file.
• Manage assigned risks and monitor potential impacts as part of the data migration plan.
• Develop best practice, processes, and standards for effectively carrying out data migration activities.
• Perform source system data analysis in order to manage source to target data mapping.
• Perform migration and testing of static data and transaction data from one core system to another.
• Perform data migration audit, reconciliation and exception reporting.
• Manage cross-program data assurance for physical data items in source and target systems.
• Configured packages with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Scheduling and maintaining SSIS packages and batch jobs thru SQL server agent on a day to day basis.
• Worked on developing tables, indexes, views, creating complex stored procedures, triggers, functions.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Assisted DBA in experience in implementing data and database security using various default database and server roles, and also, by creating user-defined as well as application roles.
• Created 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.
• Designing enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
• Deployed the solutions on web server, involved in creating user security and roles in reporting services at both parent level and report level.
• Integrated SQL server reporting services with Microsoft Office Share Point Server (MOSS) and in the Report Manager. Scheduled the reports to refresh and run on daily, weekly and monthly basis.
• Coordinate with the appropriate technical groups and Release Management. Perform the system testing and assist Application Developers and Technical support staff in identifying and resolving defects.
• Worked on dimensional data modeling using star and snowflake schemas for fact and dimension tables.
• Created and designed OLAP cubes and wrote MDX queries for calculating cube data using SQL Server 2012 and Data Analysis Expressions (DAX) & MDX queries

Confidential, Knoxville, TN

Sr. SQL/Power BI Consultant

Responsibilities:

• To migrate in house Meta Capture SQL server database to Collibra data Governance.
• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions
• Implemented complex business logic with Store procedures, User Defined Functions, Views and wrote T-SQL batches with CTE (Common Table Expressions) for recursive operations
• Created complex T-SQL queries, stored procedures for data extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, and ad-hoc queries.
• RDBMS (SQL, Oracle, MySQL,MS Access) Application Design and Development -- Implementation, Design, Administration, DB security, Performance Tuning, Data Modeling, migration.
• Extensive DDL/DML design / data quality analysis / ETL work. SQL- Query optimization expertise, including data integrity analysis for application customization testing, and creating analytical metrics.
• Involved in developing graphs using appropriate transformations for implementing the business logics in data loading
• Involved in testing the SQL Scripts for report development and SSRS and PowerBI reports
• Created materialized views as per business requirements and wrote number of stored procedure and dynamic SQL.

Confidential, Whitehouse, NJ

Sr. SQL/MSBI/ETL Techno-Functional Consultant

Responsibilities:

• Performed Server installation and configuration using SQL Server 2008R2, 2012, 2014.
• Migrated data from SQL Server 2008 R2 to the SQL Server 2012 using SSIS as ETL tool.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Involved in mock testing and Unit Testing and Integration testing in SSIS, SSAS Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Used Notification Services Available in SQL Server 2008 to create alerts and email notification.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2012 backend.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Scheduled stored procedures and wrote a batch processes.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Involved in performance tuning of the database which includes index maintenance optimizing SQL statements and monitoring the server
• Generated different reports using MS SQL Reporting Services.
• Used/Scheduled the DTS tools and services to run at different intervals in SQL Server dat are ideal for developing custom ETL routines for populating decision-support databases using ODBC.
• Designed reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading parameters.
• Developed reports using complex TSQL queries using MS SQL 2012/2014, User Defined Functions’, store procedures and views.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases and into Siemens Servers using SQL Server Integration Services(SSIS).
• Worked with various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs.
• Extracted data from various sources like SQL server 2005/2008/2012 , Oracle, CSV, Excel and text file from Client servers and through FTP.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like MS Excel, XML, Flat file and OLEDB data sources.
• Deployed the SQL Server 2008 R2/2012 SSIS packages.

Confidential, Washington DC

SQL Server Developer

Responsibilities:

• Involved in various stages like development, system Analysis &design, and creating stored Procedures.
• Designed and developed Interfaces which were used for connecting to SQL Server database.
• Validated and coded the application using VB.
• Debugged and fixed the bugs.
• Designed the Logical and Physical databases of SQL Server.
• Performed database testing & maintaining the data by using the procedures.
• Designed and validated the forms according to client requirement by using VB.
• Imported and Exported database using DTS utility.
• Wrote SQL stored procedures to implement business logic.
• Developed and coded applications in T-SQL.
• Maintained SQL Script for creation of Database Objects.

Environment: SQL Server 2000, SQL Enterprise Manager, Windows 2000/ NT, MS Access, MS Excel, VBScript.