SUMMARY

• 13+ Years of solid working experience in Information Technology that includes Design large scale of applications and product development using ETL AND OLAP, Business intelligence, designing, developing, deploying and managing databases under Production environments on Windows Platform.
• Having a 5+ Years of experience handing the L1,L2 and L3 Production support tickets.
• In - depth Technical Knowledge on Microsoft SQL Server Parallel Data Warehouse(and Microsoft Business Intelligence Tools like SQL Server 2005/2008/2012/2014/ PDW/Azure Integration Services, SQL Server, Analysis Services, SQL Server Reporting Service, Power BI, Tableau 10.0.
• Excellent detail level of understanding of various Parallel Data Warehouse components such as Name-Node, Data-Node, Distribution and partition of data/table and PDW supported datatypes.
• Expert in Extracting and Transforming data SSIS in SQL Server 2005/2008/2008 R2/2014.
• Experience inAd-hocreports, data driven subscription reports by usingReport Builder.
• Experience in developingDashboard Report, ParameterizedReports,Linked reports,Sub reportsby Region, Year, Quarter, Month and Week.
• Involved in System Analysis, Database requirements analysis, design, migration, up-gradation, database support, data warehouse creation, data mining etc.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objectscreation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Excellent academic and technical background along with good communication and interpersonal skills with domain expertise including Communication System, Financial Domain.
• Microsoft Certified Technology Specialist in Business Intelligence.
• Proficient in understanding business processes / requirements and translating them into technical requirements and Working closely with offshore development team.
• Evaluated technology risks and ensured quality deliverables with zero defects
• Involved in database design, data modeling, Development, Metadata, Tuning the SQL queries and testing the SQL codes.
• Extensive experience in implementation of Data Cleanup procedures, transformations, Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Knowledge in Business Objects XIR2 (Reports Creation), SSAS (SQL Server Analysis Services) and SSRS (SQL Server Reporting Services)
• Having B1/B2 Visa and H1B.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL\SQL,VB.NET,C#

Technologies: Data Warehousing and Data Mining.

Operating Systems: Windows 2008 / NT, XP, Vista.

Tools: Microsoft SQL Server Integration Services, SQL Server Reporting Services, Azure SQL.

Databases: SQLServer( 2005/2008/2008 R2/2013),Oracle8i/9i,PostgreSQL, SQL ServerParallel Data Warehouse(PDW).

Version Control Tools: VSS, TFS.

Scheduling Tools: SQL Agent

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. Software Engineer

Environment: Microsoft Business Intelligence Tools(SSIS,SSRS), SQL Server 2005/2008 and 2013/2014/2016 .

Responsibilities:

• Analysis of all in-use data warehouse reports to identify the Specialty Data Warehouse fields and tables respective layouts and definitions.
• Compilation of the fields to match to corresponding fields in the new Epic system
• Determination of changes needed to address similar field data between the data warehouse and the new Epic system so that ongoing data warehouse reporting needs can be met
• Requirement gathering, Estimation, Creative Development, Production Deployment, Quality metrics, Traceability matrix.
• Automation of data pulls from Source files to Data Warehouse using SSIS Packages.
• Extract and transform data from mediation data for building dimensions and fact tables by SSIS packages.
• Extract organization data and transformed into SQL tables by using SSIS packages and Transform and load fact data loaded into DWH.
• Implemented Master and child packages, parent package variables, dynamic XML configurations, SQL Server table Configurations and dynamic handling of package flows.
• Creating a design document for dashboards development
• Monitor the event alerts and notify to the concerned team and process the requests from the end users to level 2 and level 3 support engineers.
• Monitor the availability of the Database events like DB availability, Instance availability and the space availability of disk drives and file systems.
• Monitor the SQL Agent Job Alert logs files, transaction logs.

Confidential, Houston, TX

Sr. Software Engineer

Environment: Microsoft Business Intelligence Tools(SSIS,SSRS), SQL Server 2005/2008 and 2013/2014/2016 , Power BI,SSRS.

Responsibilities:

• Understand System/Application functionality and prepare a detailed System appreciation document.
• Interact with Business users and gain acquaintance on system requirements and ensure client needs are met in a timely and cost effective manner
• Effectively and accurately communicate relevant project information to the client and offshore team; also assist offshore team in crunch situations by resolving both technical and functional challenges.
• Requirement gathering, Estimation, Creative Development, Production Deployment, Quality metrics, Traceability matrix.
• Automation of data pulls from Source files to Data Warehouse using SSIS Packages.
• Extract and transform data from mediation data for building dimensions and fact tables by SSIS packages.
• Extract organization data and transformed into SQL tables by using SSIS packages and Transform and load fact data loaded into DWH.
• Implemented Master and child packages, parent package variables, dynamic XML configurations, SQL Server table Configurations and dynamic handling of package flows.
• Developed Power BI model used for Risk Remediation reporting and Headcount assets.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.

Confidential, Cary, NC

Sr. Software Engineer

Environment: SQL Server Parallel Data Warehouse 2012/2013 Microsoft Business Intelligence Tools, SQL Server 2005/2008 and 2013/2014.

Responsibilities:

• Understand System/Application functionality and prepare a detailed System appreciation document.
• Interact with Business users and gain acquaintance on system requirements and ensure client needs are met in a timely and cost effective manner
• Effectively and accurately communicate relevant project information to the client and offshore team; also assist offshore team in crunch situations by resolving both technical and functional challenges.
• Requirement gathering, Estimation, Creative Development, Production Deployment, Quality metrics, Traceability matrix and 24/7 production support.
• Installing, configuring and using SQL Server Parallel Data Warehouse components.
• Capturing data from existing databases to Parallel Data Warehouse.
• Migration of huge amounts of data from different databases to Parallel Data Warehouse.
• Automation of data pulls from SQL Server to Parallel Data Warehouse using SSIS Packages.
• Extract and transform data from mediation data for building dimensions and fact tables by SSIS packages.
• Extract organization data and transformed into SQL tables by using SSIS packages and Transform and load fact data loaded into cubes.
• Implemented Master and child packages, parent package variables, dynamic XML configurations, SQL Server table Configurations and dynamic handling of package flows.

Confidential

Software Engineer

Environment: Microsoft Business Intelligence Tools, SQL Server 2005 and 2008.

Responsibilities:

• Working closely with offshore development team and ensured quality deliverables with zero defects.
• Participating in business meetings and co-coordinating with all stakeholders.
• Responsible for developing ETL and BI applications using SSIS as per Business Rules and features of the tool
• Understanding and analyzing the requirements from the Users and designing the packages to load the data.
• Involved in New Development and major enhancements of ETL Part and Data Base designing.
• Developed ETL packages to Processing the Data on daily base from Shredding to Stage using SSIS ETL Packages as Schedule SQL Agent jobs.
• Build the master and child packages for loading all staging tables.
• Day-to-day liaison between technical and business teams and stakeholders to ensure project goals are being met.
• Writing the stored procedures and complex SQL scripts to convert the business rules into technical requirements.

Confidential

Software Engineer

Environment: Microsoft Business Intelligence Tools, SQL Server 2005 and 2008.

Responsibilities:

• Developed and Review the SSIS package for the data warehouse for ETL (Extract, Transformation and Load) operations
• Involved In requirement gathering, design approach.
• Created SSIS packages to implement data push from flat file to tables using SSIS.
• Writing stored procedures and SQL queries for data cleaning.
• Fixing daily production issues on data base side and ETL.

Confidential, Kansas

MSBI Developer

Environment: Microsoft Business Intelligence Tools, SQL Server 2005 and 2008.

Responsibilities:

• Responsible for developing ETL (Extract, transform, and load) and BI (Business Intelligence) applications using SSIS as per Business Rules and features of the tool to have one of the largest data warehouse on Microsoft platform.
• Understanding and analyzing the requirements from the Users and designing the packages to load the data.
• Involved in New Development and major enhancements of ETL Part of EVDO (Evolution-Data Optimized), CDMA (Code division multiple access) and iDEN (Integrated Digital Enhanced Network) for Nortel, Lucent and Motorola Vendor Network Data.
• Database design for Data Warehousing.
• Reading the mediation file and load the data into respective Dimension and fact tables.
• Manage user expectations, timelines and oversee estimation of projects.
• In collaboration with stakeholders, generate business case and functional requirements using project management methodology.
• Assist development team to overcome technical and domain related issues.
• SSAS Cube Design and optimize query performance by creating monthly partitions.
• Incremental process of measure groups and partitions data in cube