SUMMARY:

• 13+ years of experience in Information Technology with solid experience in playing various roles as Developer, Analyst, Lead, Architect and Project management.
• 11+ years of Data warehousing projects experience using various ETL tools and technologies like Informatica PowerCenter, AbInitio, SSIS.
• 11+ years of database experience with various RDBMS technologies like Oracle, SQL Server, Teradata, Netezza, DB2.
• 2+ years of experience in Hadoop, Spark and Big Data ecosystem in AWS Cloud environment.
• 8+ years of experience as ETL Technical Lead.
• 5+ years of experience as ETL/Data Architect.
• 2+ years of Dimensional modeling experience using Star and Snowflake schemas.
• 2+ years of experience in Project management.
• As a Big Data consultant, worked in Hadoop HDFS file system and Amazon S3 storage to transfer files across environments. Developed queries using Hive and Impala in HUE interface for data analysis and deliver reports to data stewards and business users. Also worked on Sqoop commands for data import/export between file system and databases.
• As an ETL Architect, worked extensively in setting up ETL framework and standards. Solid experience in Data Integration Architecture, Data Lineage and driving data governance along with managing the projects. Also performed Informatica Administration like installation, user management activities on need basis.
• As a Lead, experienced in Leading Analysis, Architect, Design, Development, Testing and Implementation of ETL and other dependent components. Participate in Code review and recommending best practices. Demonstrated sound analytical and diagnostic skills dealing with complex issues. Strong lead experience in effectively size and estimate development efforts. Ability to multitask and provide expertise for multiple development teams across concurrent project tasks. Ability to understand the business functionality of the project to be delivered and be as single point of contact within the team. Skills to do effective work allocation, monitoring and develop the ability of the team to scale up for taking on more work. Provides everyday updates to the manager and respective stakeholders.
• As a Developer/Analyst: Extensively worked in all the phases of project development including Business requirements gathering, converting business requirements into functional and technical specifications, Data and system analysis, Code development, Testing and Implementation of ETL and BI applications. Supported the project during warranty period and beyond that as and when needed by Production support team.
• Project management: Experienced in managing all project phases - Planning, Initiating, Design, Build, Test and Implement. Guided module leads, clearing a path for them to ensure deliverables are completed in a quality way and on time. Summarized requirements gathered, insights, execution ideas and present to all stakeholders, including senior management.
• Data Modeling: Fair understanding and working knowledge in Dimensional modeling using Star schema and Snow flake schema for DataMart. Good knowledge of Entity Relationship modeling for OLTP system and worked in creating Logical and Physical Data models.

TECHNICAL SKILLS:

Big Data / Hadoop: Cloudera Enterprise CDH, Hadoop, HDFS, Hive, Hue, HBase, Sqoop, Oozie, Spark framework

AWS Services: Redshift, S3 storage, EC2 instances

ETL Tools: Informatica PowerCenter, AbInitio, SSIS

Databases: Oracle SQL, MS SQL Server, Teradata, Netezza

UNIX Tools: Shell Scripts, Putty, WinSCP

Others: JIRA, MS Visio

PROFESSIONAL EXPERIENCE:

Technical Lead/Architect

Confidential, Whippany, NJ

Responsibilities:

• Manages, reviews and prioritizes the project work plans with objective to stay on time and on budget.
• Provides status and progress reviews to Executive Sponsor and Steering Committee.
• Created the business requirement documents and functional requirement documents per the user requirements.
• Created interface diagrams, data flow diagrams and process flow diagrams.
• Involved in creating Technical design documentation and review the code.
• Perform the data analysis and provide the updates to end users by creating adhoc SQL reports.
• Participate in technical and business requirement meetings to plan and implement the change requests.
• Created document of understandings for the application users, support team and development teams.
• Conducted JAD sessions with various SMEs and users to analyze and discuss project scope, to identify the business flows and determine whether any current or proposed systems are impacted by the new development efforts.
• Worked on the Pre- prod and production Deployment activities, provided trainings to end users by conducting WebEx sessions.
• Participated in UAT along with users to assure the quality deliverables and review the test results.
• Schedule and participate daily SCRUM meetings, executive meetings to provide the status change requests, inflow and completion of the incidents and user requests.
• Perform impact and root cause analysis to resolve user requests.
• Conduct workshops and brainstorming sessions with Enterprise architects, Solution Architects, Data stewards and Client Management team to migrate the current user platform to Bigdata.
• Configured Sqoop Client to import data into HDFS from Teradata and HDFS to Hive tables.
• Setup and configured SFTP servers to import data from third party vendors.
• Designed and Developed Data ingestion process from various sources using Apache Sqoop and Hadoop shell commands
• Developed mapping document to be used as reference by development team.

Environment: Cloudera Enterprise CDH, Hadoop, Hive, HBase, Sqoop, EC2 instance, S3 storage, Teradata

Technical Lead/Architect

Confidential, Whippany,NJ

Responsibilities:

• Conducted discussions with key business users to collect information on business user requirements and process.
• Managed Vendors, Data Agencies, Internal stakeholders to get the data associated to Marketing Mix Integration.
• Managed the project from concept to completion while managing data stewards/agencies.
• Involved in architectural improvements, design solutions and integration solutions.
• Documented Business Requirements, Technical specifications and analyzed procedures to see that they would meet changing business needs.
• Managed offshore personnel and liaised between team and business users/leadership.
• Maintained schedules to ensure that important milestones were being met at every phase.
• Implemented user acceptance testing with a focus on documenting defects and executing test cases.
• Worked with Offshore team to oversee the development activity, reviewing code and ensure the requirements and standards followed by team.
• Creating deployment groups, rollout plan documents for production migration and supporting the post production support during warranty.
• Configured Sqoop Client to import data into HDFS from Teradata and HDFS to Hive tables.
• Setup and configured SFTP servers to import data from third party vendors.

Environment: Informatica PowerCenter, Teradata, Linux, Hadoop HDFS, Sqoop, Hive

ETL Lead/Architec

Confidential, Charlotte,NC

Responsibilities:

• Working with Business Analyst to understand the functional requirements in order to transform those into technical design solutions and documentation.
• Involved in system design and architectural decisions.
• Mentoring team while implementing complex business rules for creating mappings, mapplets and reusable transformations using Informatica PowerCenter. Debugging of mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Creating deployment groups, rollout plan documents for production migration (mappings, workflows, parameter files and UNIX scripts) and supporting the post production support during warranty.
• Worked with Offshore team to oversee the development activity, reviewing code and ensure the standards followed by team.

Environment: Informatica PowerCenter, Netezza, Linux

ETL Lead

Confidential, Charlotte,NC

Responsibilities:

• Working with Business Analyst to understand the functional requirements in order to transform those into technical design solutions and documentation.
• Involved in system design and architectural decisions.
• Mentoring team while implementing complex business rules for creating mappings, mapplets and reusable transformations using Informatica PowerCenter. Debugging of mappings to identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Creating deployment groups, rollout plan documents for production migration (mappings, workflows, parameter files and UNIX scripts) and supporting the post production support during warranty.
• Worked with Offshore team to oversee the development activity, reviewing code and ensure the standards followed by team.

Environment: Informatica PowerCenter, Netezza, Linux

ETL Lead

Confidential

Responsibilities:

• Worked with business analysts to understand business requirements in order to transform business requirements into effective technical solutions.
• Involved in creation of ETL specification document and test cases documents.
• Attended weekly status meeting with the client Project Manager to provide updates on all modules within the project.
• Extensively worked on Performance Tuning at the mapping level, session level, source level, and the target level for the mappings which were taking long time to complete.
• Analyze source data for potential data quality issues and reported bad data.
• Wrote complex SQL queries to retrieve information from the databases depending on the requirement.
• Reviewed the design document and code with support team and also conducted the Knowledge transfer sessions about the project to support team.

ETL Lead

Confidential

Responsibilities:

• Analyzing the requirements and having discussion with onsite and business team to understand the requirements.
• Involved in Low level design document, ETL specification document and test cases documents.
• Created the Graphs for business requirements also to help the team in their design process, involved in code reviews as the offshore lead in this project.
• Extensively worked with Slowly Changing Dimensions (SCD) and Incremental Loading.
• Created and Documented ETL test plans, test cases, test scripts, expected results, assumptions and validations for unit, integration and system tests for mappings developed.
• Involved in post-production support and monitoring the activity in various environments.
• Involved in Effort estimation for ETL Design and Development.