SUMMARY

• Over 8 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Testing of Applications in Data warehouse, OLAP with strong business knowledge ofFinancial, Marketing, Manufacturing and utility industries.
• Designing, implementing, optimizing, troubleshooting and delivering highly scalable and performance database solutions
• Good exposure on Data Modeling and Data analysis.
• Excels in at Data Warehousing, ETL and Reporting Services
• Worked on all phases of Data Warehouse development lifecycle. Designing and implementing data warehouses and data marts using components of Kimball Methodology, like Data Warehouse Bus, ConformedFacts & Dimensions, Slowly Changing Dimensions, Surrogate Keys, Star Schema, Snowflake Schema, etc.
• Demonstrated expertise utilizing ETL tools like SQL Server Integration Services (SSIS) and data quality services tools like DQS.
• An In - depth grasp of Business Intelligence reporting tools like SSRS, Tableau and Power BI
• Proficient in building Database Schemas, Designing Tables, Optimizing Queries, Tuning Indexes, writing efficient Stored Procedures, Views and Functions
• Worked on Teradata utilities BTEQ, Fast Load, Multi Load, View point etc
• Comprehensive Working knowledge of administrative roles such as Backup and Recovery, Index Design and Maintenance, Monitoring and Automation, Performance Tuning and understanding Execution Plans, High Availability and Disaster Recovery.
• Technical Knowledge on core AWS services like EC2, RDS, S3, Lambda etc. and Big data/Hadoop concepts with Python scripting.
• Developed front end self-service tool for Invenio Call Coaches to scrub mobile numbers and ‘Do not call’ list, which is used company wide.
• Trained business users across the company on visualization reporting tools like POWER BI and TABLEAU
• Career Personal Highlight ~ earned superlative accolades from peers and superiors alike for dedicated & consistent contribution to the projects as in frequently being addressed by the CIO as the Data Whisperer
• Won ‘Most likely to be asked for help’ for Invenio Superlative Contest-2015 based on employee voting.

TECHNICAL SKILLS

Database: SQL Server 2005/08/12/14 , Teradata 12, Oracle 9g, Confidential Access, My SQL.

ETL Tools: SQL Server Integration Services 2008/08 R2/12/14 (SSIS), Informatica

Reporting Tools: SQL Server Reporting Tools 2008 R2/12 (SSRS), Power BI Desktop, Tableau 9.0/9.1., QlikView.

Database Tools: Performance Monitor, View Point, SQL Profiler.

Cloud Technologies: AWS services (EC2, RDS, S3, Lambda), Salesforce CRM, MS Dynamics CRM

Data warehousing Tools: Master Data Services (MDS), Data Quality Services (DQS), SSAS, ERWIN, VISIO

Coding Languages: C, C#, SQL, PL-SQL, Python.

Version Control: Team Foundation Server 2012, Subversion (SVN)

Bigdata Ecosystem: HDFS, Spark, Hive, Kafka, Sqoop, Flume, Spark, Oozie, Zookeeper

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr Data Engineer

Responsibilities:

• Involved in understanding functional requirements, translation of technical documents and data mappings
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, implementation, testing and support. Involved in dimensional modeling of the data warehouse to design dimensions, facts, Star Schema and Snow flake schemas.
• Contributed to building out reporting architecture to provide business intelligence to Business Managers and Higher management.
• Developed, Deployed and Scheduled SSIS packages to load data from different sources like Salesforce, CRM dynamics, SQL server, flat files, Excel etc. into data warehouse
• SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations to load in to DW
• Developed Reports and Dashboards and created subscriptions for Internal Business users, HR team, Clients and for higher management using SSRS, POWER BI and Tableau.
• Created Standard Process Template for all the SSIS packages which was later used throughout the company.
• Implemented Cleansing process and data profiling using DQS tasks in SSIS packages for detecting and correcting inaccurate data from the sources and to track data quality.
• Responsible for DBA activities like Backup/Restore of databases, troubleshooting security issues, performance issues, clustering, replication, monitoring of space utilization and adding space as required, High Availability and Disaster Recovery.
• Compared Different Business Intelligence tools like Tableau, Domo, Tibco Spotfire, Power BI, Sisense and suggested Tableau for Mangers based on business user requirements, cost and ease of use.

Environment: Windows, SQL Server 2012/14, MySQL, SSIS, SSAS, SSRS, Tableau, PowerBI, QlikSense,TFS, Salesforce, Confidential Dynamics CRM, DQS, MDS,C#

Confidential, Redmond

ETL Migration Consultant

Responsibilities:

• Participated in requirements gathering and creating functionalrequirementsfor Migration of data from legacy SQL server to Confidential Dynamics CRM
• Developed SSIS Packages to move data from one database of a server (Partner) to another (CRM) using Web Services Call using various transformations such as Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Built Controller Package which will integrate all the other packages
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Worked individually on designing Technical Specification documents by gathering required logic for the Package.
• Created Standard Template for all the development packages which includes Row Level Logging, Event Handlers and Call to Web services.
• Created deployment environment for the packages to migrate data to CRM.

Environment: Windows, SQL Server 08/12, SSIS SSRS, TFS, Dynamics CRM,DQS,MDS.

Confidential, Minneapolis

Database Developer(Intern)

Responsibilities:

• Responsible for migrating data from SQL server to Teradata using Teradata utilities, SSIS and Informatica.
• Hands on experience in Teradata SQL, Tools & Utilities (Fast Export, Multiload, Fast Load, tpump, BTEQ and Query Man).
• Performance tuning of Queries and Stored Procedures with the help of Explain Plan Used VIEWPOINT for monitoring the query performance of Teradata systems.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: UNIX, Windows, Teradata 12, SQL Server 2008, View Point, Informatica, SSISSSRS, Subversion,Multiload,, Fast Load, TPump, BTEQ

Confidential

MSBI Developer/DBA

Responsibilities:

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code for applications
• UsedSSISto createETLpackages to validate, extract, transform and load data to data warehouse and data marts.
• Developed various operationalDrill-throughandDrill-downreports and different kind of reports such aSub Reports,Charts,Matrix reports,Linked Reports usingSSRS
• Responsible for Database administration tasks like security, backup/recovery, high availability and Disaster recovery of databases

Environment: Windows, SQL Server 05/08, SSIS, SSRS, Subversion, C#,SQL Profiler