CAREER OVERVIEW

Over all *+ years of experience as MSBI Consultant, skilled in Business Intelligence, ETL Technologies, SQL Scripting, Data Analysis, Power BI, Agile Methodologies.

Expertise in Data Warehousing, Data Migration, Data Integration, SQL Service Integration Services & SQL Server Reporting Services.

Worked with SQL Server tools Such as Management Studio, Execution plan, SQL Profiler, SQL Agent and SSIS/Catalogs.

Used Power BI to collaborate with different users and stakeholders to work on live data sources.

Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.

Experience in data Normalization, Data Modeling and generating mapping documents.

Experienced and proficient in various phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Expertise in Data Extraction, Transforming and Loading (ETL) using the tools such as SQL Server Integration Services (SSIS) & Bulk Insert.

Migrated DTS Packages to SSIS using various versions of SQL Server.

Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts and schedule SSIS packages using SQL Agent.

Experience in troubleshooting SQL issues by using tools like Execution plan, Trace and 3rd party tools/techniques.

Have experience in Performance Tuning, T-SQL Query Optimization.

Performed data profiling and analysis using Data Profiling Task in SQL Server Integration Services.

Experience driving in-person discussions with senior personnel regarding best practices, project management and risk mitigation for data warehousing.

Experience in bulk importing CSV, XML and Flat files data using Bulk Copy Program (BCP).

Experience in developing Inbound and Outbound process for file import and export through FTP and SFTP by using SSIS.

Experience in database administration tasks like Deploying, Scheduling and Monitoring the ETL jobs.

Experience in coordination with Data Integration, Network, DBA, Server Systems and Storage Systems for cross-team projects, resource procurement, system maintenance and upgrades and change management.

Worked in Agile team with frequent releases and providing immediate solutions for business needs.

Experience in writing Expressions in SSRS and finetuning the reports. Created many Drill-through and Drill-down reports and created Subscriptions to deliver reports.

Experience in Error handling, Debugging and Error logging for production support in SSIS.

Documented all aspects of ETL processes, definitions and mappings to support knowledge transfer.

SELECTED ACCOMPLISHMENTS

Optimized long running jobs by using multiple performance optimization techniques.

Migrated Legacy SSIS projects from SQL Server 2012 to SQL Server 2016.

Created Automated jobs that generate thousands of reports, which drastically reduced manual efforts.

Designed & developed a Datawarehouse project to support Analytical reporting.

CAREER SUMMARY

Data Engineer Msbi Developer ETL Developer

Data Analyst SQL Developer Datawarehouse Developer

Data Analytics

CORE COMPETENCIES

Teamwork: Interacts with people effectively. Able and willing to share and receive information.

Problem Solving: Able to detect, recognize and define problems. Analyzes problem by gathering, reviewing and organizing all relevant information.

Communication: Able to determine the most appropriate method of communication. Able to interpret information correctly.

AWARDS & RECOGNITIONS

Received Gold Award for completing Performance Improvement-Load Efficiency Task.

Awarded On The Spot Award for delivering maximum output in Single Agile Sprint.

EDUCATIONAL PROFILE

Bachelors in Computer Science Engineering.

PROFESSIONAL EXPERIENCE

July 2019 – Present

ROLE: Data Engineer (ETL Developer and Data Analyst)

CLIENT: Tata Consultancy Services

Responsible for redesign existing legacy SSIS projects to process large volumes of Policy & Claims data from row by row to Batch processing, along with detailed auditing guidelines, working with external Audit teams as part of quarterly attestation process & create/update report subscriptions on downstream data per Stakeholder’s requests.

RESPONSIBILITIES AND ACCOMPLISHMENTS:

Collaborated with project teams to organize meetings and gather business requirements from business users and SMEs.

Maintained referential, domain, and entity integrities with available options such as constraints and triggers.

Incorporated database objects with T-SQL such as stored procedures, UDFs, triggers, and indexes to create complex scripts and batches.

Utilized CTEs, views and temporary tables to store intermediate results of complex queries for further operations.

Implemented different indexing strategies for query optimization such as covering indexes, indexed views, and index defragmentation.

Designed and tested (Unit, Integration and Regression) packages to Extract, Transform and Load data using SQL Server integration services (SSIS).

Utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting in SSIS Packages.

Implemented event handlers, loggings, and data viewers for effective debugging of SSIS packages.

Identified different dimensions and fact tables to be included within the target OLAP system.

Utilized various connection managers in SSIS package such as OLEDB, Flat file, and Excel to extract data from different kind of sources and transferred them into staging area.

Made use of Event Handlers, Loggings, Breakpoints and Data Viewers for effective debugging of packages.

Configured and deployed SSIS packages to the production server with parameters in the SSISDB catalog.

Involved in re-design and deploy new data extractions using SSIS and designed, produced documentation of data transformations for all extractions.

Created different types of reports like drill down reports, drill through reports, sub reports and parameterized reports.

Designed reports to include charts and logos that compiles with organizations culture and policies of reporting and documentation.

Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, and monthly and quarterly reports.

Improved the performance of reports by optimizing data sets, making sure use of report caching and snapshots along with talking into consideration networking aspects.

Strong experience in using Power BI query editor feature like merge and append query, split column, conditional extract.

Utilized Power query in Power BI to pivot and un-pivot data model for data cleansing and data massaging.

Designed ad-hoc reports in excel power pivot and shared them using Power BI to the decision makers for strategic planning.

ENVIRONMENT: Visual Studio 2008, 2010, 2013 & 2015, SSIS, SSRS, Power BI.

May 2018 – July 2019

ROLE: Data Engineer (ETL Developer and Data Analyst)

CLIENT: Tata Consultancy Services

Responsible for implementing/modelling a Datawarehouse project that contains information on policies & claims processing to manage health insurance claims. And ensure the reports are being generated per underwriter’s requests.

RESPONSIBILITIES AND ACCOMPLISHMENTS:

Worked with the business intelligence team to create a new Data warehouse for Data analytics & reporting purposes.

Designed and tested (Unit, Integration and Regression) packages to Extract, Transform and Load data using SQL Server integration services (SSIS).

Utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting in SSIS Packages.

Created stored procedures and utilized data profiling task in SSIS to profile data and understanding potential problems with data quality.

Created various ad-hoc SQL queries for customer reports, executive management reports and types of reports like Tablix, matrix & sub reports etc.

Created different types of reports like drill down reports, drill through reports, sub reports and parameterized reports.

Designed reports to include charts and logos that compiles with organizations culture and policies of reporting and documentation.

ENVIRONMENT: Visual Studio 2008, 2010, 2013 & 2015, SSIS, SSRS, Power BI.

Mar 2016 – Mar 2018

ROLE: Developer (SQL Developer)

CLIENT: Value Labs

Responsible for delivering the assigned JIRA tickets on time. These JIRA tickets include requests to add/alter Core/Additional attributes in existing data ware house.

RESPONSIBILITIES AND ACCOMPLISHMENTS:

Worked on Creating stored procedures, Functions & SQL Agent Jobs.

Performed SIT & Unit testing. Responsible for UAT hand holding and defects resolution. Responsible for providing direct support to users on production issues.

Worked with Business to understand the process better & come up with more efficient ways to present data for our end users.

Worked extensively on the Standard transformations like Data conversion, Lookup, Merge, Union all, Conditional Split, SQL task, Script task & Send mail etc. Created triggers to send emails, update status for the Business development Managers & IT depot.

Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.

Designed SQL Server Database and Table Design with Schemas, Constraints and Views.

Created SSIS packages which involved a variety of transformations such as look up, Aggregate, Derived Column, Conditional Split, Union All and Data Conversion before loading the data into Data Warehouse.

Review the code changes made by peer developers before deploying to higher environments.

Part of the Agile/Scrum team and participated in Standup, Grooming, Planning and Retrospective meetings.

ENVIRONMENT: SQL, Visual Studio 2008, 2010, 2013 & 2015, SSMS.

Jan 2015 – March 2016

ROLE: Trainee (SQL Developer)

CLIENT: Thermo Cables

Responsible for adding new data elements (or attributes) customers seek to see in the final reports. Making sure the data integrity & business functionality remains intact.

RESPONSIBILITIES AND ACCOMPLISHMENTS:

Created new SQL objects (like tables, views, triggers & indexes).

Worked on Creating & Updating stored procedures, Functions & SQL Agent Jobs.

Performed SIT & Unit testing. Responsible for UAT hand holding and defects resolution. Responsible for providing direct support to users on production issues.

ENVIRONMENT: Visual Studio 2010, SSMS 2012.

COMPUTER SKILLS, TOOLS AND METHODOLOGIES

Data Warehousing /ETL Tools: SQL Server Integration Services 2008, 2012,2014 and SQL Server Reporting Services 2012, Power BI.

Databases: SQL Server 2008R2/2012/2014/2016.

Programming Languages: T-SQL, PL/SQL, C#.

Business Modeling Tools: JIRA.

Other Tools: TFS, Redgate.

SDLC Methodologies: Waterfall, Agile.

Contact this candidate