OBJECTIVE:

• To pursue a career in the field of information technology that offers me an opportunity for the career growth.

SUMMARY:

• Over 11+ Years of experience with Hadoop, Pig, Hive, Cosmos, I Scope, MSBI (SSIS, SSAS, SSRS) and MS SQL Server 2005/2008/2008 R2/2012/2014, C#, Power Pivot,, Power Shell, Tableau, mongo DB as a Senior/Lead/Manager in financial, insurance, healthcare and retail companies
• I’ve been working for Banking, Insurance, and Manufacturing industries. Worked on different technologies including BigData, SSIS, SSAS, SSRS with MDX and SQL, Pro Clarity, SQL SERVER, ORACLE

TECHNICAL SKILLS:

Big Data Ecosystems: Hadoop, MapReduce, HDFSHBase, zookeeper, Hive, Pig, Sqoop, Oozie, Flume

Microsoft Big Data: Cosmos, I scope, PowerShell

Programming Languages: C#.NET

ETL: SQL Server 2005/2008/2012/2014 Integration Services

OLAP Tools: SQL Server 2005/2008/2012 Analysis Services, PowerPivot

Database: Oracle, SQL Server 2005/2008/2012/2014 , NoSQL

Reporting Tools: SQL Server 2005/2008/2012 Reporting Services, ProClarity, Tableau

Operating Systems: Windows XP, Windows 2003, Windows7/8/10

PROFESSIONAL EXPERIENCE:

Confidential

Developer

Responsibilities:

• Created SSIS Packages
• Created Stored Procedures
• Job monitoring and Issue Resolution

Confidential

Lead

Responsibilities:

• Created SSIS Packages for Conversion
• Enhancement of SSIS packages through initiative tickets using Jira
• Provide support in database architecture of the organization through database design, modeling and implementation
• Prepare invoice reports and manage offshore team
• Responsible for offshore delivery
• Created stored procedures
• Created Workflows, jobs in Informatica and MDM
• Job monitoring and scheduling the SSIS packages
• Agile/Scrum methodology implementation

Confidential, Redmond,WA

Lead Developer

Responsibilities:

• Created SCOPE scripts for Videos
• Created SSIS Packages
• Provide support in database architecture of the organization through database design, modeling and implementation
• Created Tabular Cubes
• Created stored procedures, views, synonyms
• Job monitoring and scheduling the SSIS packages
• Lead/mentor the team to achieve the assigned tasks

Confidential, Redmond,WA

Lead Developer

Responsibilities:

• Created PowerShell Script
• Created Scope scripts as per business logic
• Created stored procedures, views, synonyms
• Created Tabular Cubes
• Job monitoring and scheduling the SSIS packages
• Lead/mentor the team to achieve the assigned tasks

Confidential, Redmond,WA

Lead Developer

Responsibilities:

• reated SSIS Packages for EDW and ET data mart
• Written Views, CTE
• Automated jobs without manual intervention
• Lead/mentor the team to achieve the assigned tasks

Confidential, Redmond,WA

Lead Developer

Responsibilities:

• Analysis of data and specification documents
• Added new columns to the existing tables in COLL01, HC01, SCST01, HCH01 and SDMN01 datasets.
• Created new tables in HC01 and SDMN01 datasets
• Created stored procedures for FSP service to get customized feed data (multiple tables) from feed store to FSP database.
• Created Run books during the transition period
• Lead/mentor the team to achieve the tasks during the AQR release

Confidential

Lead Developer

Responsibilities:

• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW tables and historical metrics.
• Enabled speedy reviews and first mover advantages by using Oozie to automate data loading into the Hadoop Distributed File System and PIG to pre - process the data.
• Provided design recommendations and thought leadership to sponsors/stakeholders that improved review processes and resolved technical problems.
• Managed and reviewed Hadoop log files.
• Tested raw data and executed performance scripts.
• Shared responsibility for administration of Hadoop, Hive and Pig.

Confidential

Onsite Developer

Responsibilities:

• Worked on SSIS Packages for Claims.
• Created Data Quality reports for different Sources and Subject areas based on attributes, money at summary and money at detail.

Confidential

Developer

Responsibilities:

• Generated Reports using Cube
• Created reports using Report builder 2008.
• Worked on SSIS Packages
• Prepared Unit Test case Specification
• Good Knowledge on optimizing the reports, MDX queries.

Confidential

Developer

Responsibilities:

• Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services
• Developed the cube (FuturesDW)
• Developed the Reports in ProClarity and SSRS as per specifications.
• Used different transformations for applying the business logic
• Written Stored Procedure and Functions
• Created various reports in ProClarity and SSRS.

Confidential

Developer

Responsibilities:

• Development of packages according to the ETL specifications for the staging area & warehouse data loading using SQL Server Integration Services & SQL Server 2005..
• Importing Source/Target tables from the respective databases by using Execute Package Task& using Control Tasks in SQL Server 2005 Integration services.

Confidential

Developer

Responsibilities:

• Primarily responsible for developing applications in SSIS as per Business Rules and features of the tool.
• Importing Source/Target tables from the respective databases by using Execute Package Task using Control Tasks in SQL Server 2005 Integration services.