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 Power BI, Cosmos, MSBI (SSIS, SSAS, SSRS), Hadoop, Pig, Hive,, 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, Power BI, DAX and SQL, Pro Clarity, SQL SERVER, ORACLE

TECHNICAL SKILLS:

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

Confidential 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: SSRS 2005/2008/2012 , ProClarity, Tableau, PowerBI

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

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Developer

Responsibilities:

• Design and Developed SSIS Packages
• Design Dimensional Model for Datawarehouse
• Created Stored Procedures for data transformation from source to destination
• Design and Developed Tabular Cubes
• Developed Power BI visualization reports using Power BI Desktop
• Created Calculated measures in DAX
• Job monitoring for production support and for successful runs.
• Issue Resolution for adhoc business requests

Technologies: SSIS 2016, SSAS 2016, SQL Server 2016, T - SQL, Visual Studio 2017, MDS(MasterDataServices), PowerBI,DAX

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

Technologies: SSIS 2014, SQL Server 2014, T-SQL, Visual Studio 2015, TFS, Informatica, MDM, Confidential Dynamics CRM, Jira

Confidential, Redmond, WA

Lead Developer

Responsibilities:

• Created SCOPE scripts for Videos in Office site
• 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

Technologies: Big Data (Cosmos), SSIS 2014, SQL Server 2014, Tabular Cubes,T-SQL, Visual Studio 2013, TFS, C#

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
• Developer reports in Power BI
• Lead/mentor the team to achieve the assigned tasks

Technologies: Big Data (Cosmos), MIST 2.0, SSIS 2014, SQL Server 2014, T-SQL, Visual Studio 2013, TFS, PowerShell,Power BI

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

Technologies: SSIS 2012, Azure, SQL Server 2012, T-SQL, Visual Studio 2013, TFS

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

Technologies: SSIS 2012, SQL Server 2012, T-SQL, Visual Studio 2013, TFS, MS Visio 2013, Erwin

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 reference 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.

Technologies: MapReduce 1.x,Hive,Pig,Tableau

Confidential

Onsite Developer

Responsibilities:

• Created Data Quality Packages for different Sources
• 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.

Technologies: SSIS 2008,SQL Server 2008 R2,SSRS 2008,Power pivot, Share point

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.

Technologies: SSIS2005,SSAS 2005,SSRS 2005