SUMMARY

• Over 9 years of experience in BI(Business Intelligence),Data warehouse Applications
• Working closely with the Stakeholders, Business teams (Department specific managers). To understand their requirement, gathering the source data & specific metrics methodologies.
• Expertise of Hadoop MRV1 and Hadoop MRV2 (or) YARN Architecture.
• Expertise in developing HIVE scripts for data analysis.
• Expertise on big - data database HBase and NoSQL databases Mongo DB,Cassandra.
• Capable of taking the responsibility & accountability of developing, deploying & maintaining the Database & BI projects
• Strong negotiable skills in understanding Data Management. Where I can help the Business team how to interpret or reconcile the data from the sources itself.
• Trained internal, external teams& end users on various API client likePentaho,DVL & SSMS.
• In-depth knowledge of large database design techniques; experience indata analysis, data cleansing, and data transformationandmigration using ETL tools.
• Lead and served as subject matter expert on projects requiring extensive requirements gathering, data analysis, data modeling, ETL, dashboard design/development and testing
• Worked with customer closely to understand business issues quickly and translate those into solutions on thereportingplatform
• Ability to work independently and manage multiple tasks concurrently
• Experience in presenting project details and progress to the clients at various stages.
• Experience in working with Business Analyst's and in gathering business requirements from them
• Having experience in leading the support team for the production environment, including incident support and enhancements.
• Experience in working with BMC CONTROL-M.
• Experience in creating data templates in the Composite Studio 6.0 from various data sources.
• Creation and configuration of physical and logical layers, setup of various data sources in multiple environments and performing re introspection of data sources and their objects

TECHNICAL SKILLS

RDBMS: SQL Server, Sybase, Greenplum, Oracle

ETL Tools: Pentaho Kettle, SSIS

Reporting Tools: SSRS, Crystal Reports, Pentaho Reporting Tool.

EA Technologies: Composite Studio 6.0, Control -M

Big Data: HIVE, HBASE, SQOOP

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Developer

Responsibilities:

• Client Interaction.
• Writing of database queries and T-SQL Procedures.
• Created tables, views, triggers, stored procedures and indexes.

Confidential, NY

Big Data Developer

Responsibilities:

• Involved in requirement gathering phase.
• Analyze and translate functional specifications and change requests into technical specifications.
• Responsible for laying down ETL architecture from scratch to end deliverables based on requirements.
• Responsible for designing and setting up ETL processes to and from a High volume data warehouse
• Developed and tested extraction, transformation, and load (ETL) processes.
• Composite DVL views setup for the required data sources.
• Develop Queries to pull the data from various data sources.
• Develop Transformations/Jobs to transform the data into required format.
• Preparation of HLD,LLD and L1L2 documents.
• Lead Unit and Integration Testing activities and assist in User Acceptance Testing.
• Scheduling the jobs through Control-M

Environment: Pentaho Kettle, Greenplum, Sybase, SQL Server, Composite DVL, Control - M,APPM

Confidential, NY

Responsibilities:

• Used Hive data warehouse tool to analyze the historic data in HDFS to identify issues and behavioral patterns.
• Loading the Data to HIVE Tables through Pentaho Kettle.
• Creation of Composite DVL views.
• Worked extensively with Sqoop for importing data from multiple sources.
• Involved in creating Hive tables, and loading and analyzing data using hive queries
• Extending Hive functionality by writing custom UDFs.
• Created partitioned tables in Hive.

Environment: Pentaho Kettle, Sybase, Hive,Sqoop, Composite DVL, Control - M,APPM

Confidential

Big Data Developer

Responsibilities:

• Analyze and translate functional specifications and change requests into technical specifications.
• Responsible for laying down ETL architecture from scratch to end deliverables based on requirements.
• Responsible for designing and setting up ETL processes to and from a High volume data warehouse
• Developed and tested extraction, transformation, and load (ETL) processes.
• Composite DVL views setup for the required data sources.
• Develop Queries to pull the data from various data sources.
• Develop Transformations/Jobs to transform the data into required format.
• Preparation of HLD, LLD and L1L2 documents.
• Lead Unit and Integration Testing activities and assist in User Acceptance Testing.
• Scheduling the jobs through Control-M

Environment: Pentaho Kettle, Greenplum, Sybase, SQL Server, Composite DVL, Control - M, APPM

Confidential

Senior Analyst

Responsibilities:

• Client Interaction.
• Writing of database queries and T-SQL Procedures.
• Created tables, views, triggers, stored procedures and indexes.
• Developed distributed queries for Linked Servers.
• Used Integration Services (SSIS) to solve complex business problems.
• Developed reports using SQL server reporting services (SSRS).
• Involved in unit testing and functional integration testing of EDMS application.

Environment: - Control-M, Microsoft SQL server 2005, Sybase,SQL SCRIPTS, SSIS.

Confidential

IT Analyst

Responsibilities:

• Client Interaction.
• Writing of database queries and T-SQL Procedures.
• Created tables, views, triggers, stored procedures and indexes.
• Developed distributed queries for Linked Servers.
• Used Integration Services (SSIS) to solve complex business problems.
• Involved in unit testing and functional integration testing of EDMS application.

Environment: Control-M, Microsoft SQL server 2005, Sybase, SQL SCRIPTS, SSIS

Confidential

IT Analyst

Responsibilities:

• Responsible for developing SSIS automation including all error handlings.
• Responsible for developing business Objects for Database Tables.
• Database and application’s test server’s maintenance.
• Involved in Unit testing
• Utilized features such as multiple tables, visualizations, drill down and other analyticsreporting and analysis tools to deliver business insights.
• Utilized multiple visualizations, calculated columns, summations and pivoted tables to demonstrate value of opportunities
• Created and managed stored procedures and triggers, distributed data, database replication, database optimization, determining common performance problems, monitoring, configuring servers.

Environment: Microsoft SQL server 2005, SSIS, SSRS

Confidential

DB and ETL Developer

Responsibilities:

• Collect requirements and identify the business needs
• Involved in creating the entire Database structure
• Responsible for developing business Objects for Database Tables.
• Spreading the table and index data on different table spaces for better performance.
• Responsible for developing SSIS automation including all error handlings
• Responsible for performance tuning of the SQL SERVER 2005 and 2008
• Involved in Unit testing
• Developed reports using Crystal Reports.

Environment: SQL SERVER 2005, MSBI,Crystal Reports, ASP.NET

Confidential

DB and ETL Developer

Responsibilities:

• Supporting Build Acceptance Testing, Automation, Product Integration Testing and Performance Testing.
• Involved in Requirement gathering.
• Creating reports using the Crystal Reports and publishing them on the server.
• Data Migration through SQL Loader.
• Developing Queries.
• Developing PL/SQL script(Procedures, Views)
• Unit Testing
• Support Build activities.

Environment: Oracle 10g, ASP.NET

Confidential

Database Developer

Responsibilities:

• Coordinating with cross-functional teams for data and quality analysis.
• Validating the data with various process in Asset Management..
• Writing of database queries and PL/SQL Procedures.
• Working with Link tables in oracle.
• Unit Testing.

Environment: Oracle 10g, ASP.NET

Confidential

Database Developer

Responsibilities:

• Developing SQL queries.
• Created Stored Procedures.
• Developing WebPages using ASP.NET.
• Unit Testing

Environment: Oracle 8i, ASP.NET