SUMMARY:

• Data Integration specialist having more than 12 years of work experience on leading, designing, delivering robust, scalable, and highly available Data warehouse and Business Intelligence solutions.
• Involved in data modeling using IBM infosphere Data Architect tool and data profiling performed using Informatica Data Quality and BI reporting technique for various reports to improve the business performance.
• Built the Enterprise Data Lake and Data Warehouse
• High attention to detail, organization, team - orientation, and an able to work under tight deadlines
• Expert in Informatica client tools, willing to develop and test ETL Mappings and help the team to adhere to the Industry standards.
• Expert in building Data Migrator (Information Builders) ETL job to pull data from various sources (SQL Server, Oracle, Google Analytics, Rest API).
• Strong experience in writing complex SQL queries, Data Modeling and ETL Strategy
• Experience in AWS services such as S3, Kinesis, Redshift, Lambda and Cloud watch
• Work closely with Business Agile Partners, Stakeholders, Solution Architect, Data Modelers to understand business Requirements and Provide DWBI Solutions in a timely cost-effective manner with the company’s architecture and SAFE Agile standards.
• Having experience in working on various file types like delimiter files, XML and JSON files.
• Hands-on experience in handling online messages like AMQ, REST API’s and Webservices.
• Knowledge and Hands-on experience in Hadoop tools like HDFS, MapReduce, Hive, Pig, Kafka and Hortonworks framework.
• Strong experience in writing advanced SQL, Performance optimization in Informatica and Talend tools, Problem-Solving skills to analyze and resolve issues.
• Ensure timely and accurate resolution of production issues and monitoring the event logs and Server error logs for troubleshooting purposes.
• Participates in release management activities & manages all tasks associated with project transitions
• Proactively keeps customer informed of how and when problems are resolved with focus on retention
• Gather requirements from stakeholders including business subject matter users and IT teams
• Document data migration requirements, including source system analysis and source to target
• Analyzes & acquires data from primary and secondary data sources - creating mapping specifications for use by ETL development resources
• Involved in creating data mapping between salesforce CPQ and Data warehouse environment.
• Documents plans for collection, data cleansing, and normalization of data
• Have proven experience in System analysis, design, development, Data Warehouse/Data Mart design, RDBMS and implementation of client server applications in SDLC and Agile methodology.
• Used IDQ tool for address validation using address doctor reference data.
• Involved in data analysis, profiling and cleaning the data like labeling, standardization, preparing Reference data and data consolidation for golden record using IDQ.
• Having good experience in preparing reusable objects like ETL Transformation, Session, Mapplets, Worklets and User Functions.
• Delivered most of the projects under Agile Methodology.
• Over THREE years of experience in EDI conversions for 837I, 837P and NCPDP Government Submissions.
• Extensive experience with various scheduling tools like CA7 & Maestro & Appworx scheduler.
• Strong in performance tuning of complex SQL queries.
• Very flexible and can work independently as well as in a team environment.
• Involved in Preparing HLD, LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation.

TECHNICAL SKILLS:

Operating System: UNIX/Linux, MS-DOS, Windows 2008/2007/ NT/2000/XP.

ETL Tools: Talend 6.x, 7.1.1, Informatica Powercenter 9.6.1/8.5.1/7. x/6.x, PowerExchange for MainFrames VSAM file, Informatica Data Quality (IDQ), Informatica Analyst, Master Data Management, Talent.

Data Modeling Tools: Erwin, ER Studio, IBM Infosphere Data Architect 9.1.3.

BI Tools: Cognos (Framework Manager, Query studio, Report Studio), Qlikview, POWER BI.

Database: Teradata, MS SQL Server 2008, DB2, Oracle 11g.

Language/Scripting: UNIX Shell Scripting.

Other Tools: Ultra-Edit, Altova XML Spyware, TOAD, SQL Developer, WinSCP, Putty, Quick View, IBM Rational Clear Case, Clear Quest, Build forge, Power Designer, IT2B, Teradata SQL Assistance, Microsoft Visio (Visio Soft Diagram), Control-M, TOAD, IBM Maestro - Scheduler, AQT.

PROFESSIONAL EXPERIENCE:

Confidential, Ann Arbor, MI

Data Integration Specialist (Informatica) - B2B - Store data Integration

Responsibilities:

• Involved in understanding Business Process and coordinating with Business-users to get specific user requirements to build the Data Marts.
• Documented user requirements translated requirements into system solutions and develop implementation plan and schedule.
• Integrating Adobe click streaming data for more analysis.
• Building the Driver app to track the store order delivery with the graphical structure.
• Big data components used like Hive, HDFS and spark for handling huge data.
• Modeled the Star Schema Data Marts by identifying the Facts and Dimensions using Idera Data modeling tool.
• Created jobs in Talend Data Integration tool to extract from heterogeneous data sources like SQL Server 2016, AMQ messages and Oracle 10g.
• Involved in the handling the various store files across domestic and internationally.
• Data are shared across different system using AMQ messages and JSON files.
• Provide the 24/7 production support on various applications.
• Used Talend Data Integration tool to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouse database.
• Ensure timely and accurate resolution of production issues and monitoring the event logs and Server error logs for troubleshooting purposes.
• Monitored and scheduled existing/new jobs on production environment.
• Builds and maintains strong relationships with business partners and technology teams to identify process improvement opportunities.
• Knowledge of incident, problem management, ticket, change, and risk management processes and tools
• Serves as primary support liaison between company and customer and documents incidents in required tracking systems.
• Create and modify reports using various reporting and analytical tools for data mining and ad hoc reporting as well as identify areas where efficiencies can be achieved through automation.
• Responsible for being the liaison with Development and other departments to insure proper handling of customer issues.

Environment: Informatica PowerCenter, MS SQL Server 2017, Talend Studio, AWS, BIG Data, Control-M

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Gather requirements from stakeholders including business subject matter users and IT teams
• Document data migration requirements, including source system analysis and source to target
• Communicating/Connecting the BRD and development team with proper process flow and mapping document.
• Involved in building the data warehousing for maintain the policy information with snowflake schema.
• Involved in creating dimension and fact tables.
• Involved in System analysis, design, development, Data Warehouse/Data Mart design, RDBMS.
• Identified and finalized various source systems to fetch the requisite information.
• Involved in performance tunning by writing complex and effective SQL.
• Involved in table partition for better performance.
• Key activities include managing deliverables, managing cross location teams, onboarding/offboarding of resources & attrition
• Client management to capture expectations and draw roadmap with regular milestones
• Created unit test cases and test scripts to validate data.
• Review the detail level design and ensure that the IT standards are followed
• Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.

Environment: Data Quality, Oracle 11g, IBM infosphere Data Architect, Salesforce CPQ, MS SQL Server 2008, Windows XP, UNIX, Flat Files.

Confidential, Richmond, VA

Technical Lead

Responsibilities:

• Involved in data analysis, profiling legacy data and cleaning the data for better data quality.
• Used address doctor reference data for client address validation using MDM.
• Involved in preparing the Reference data for maintain the data standardization.
• Build the golden record using data consolidation concept in IDQ for better data quality.
• Creation of the high level design and tool deployment architecture
• Understanding the user requirement and preparing the sourcing spec for source system.
• Involved in source system call to make the source team to understand the requirement of development.
• Understanding the requirements and build end to end informatica development mapping spec.
• End to end Mapping, session, workflow development and migrating to UAT and Prod environment.
• UNIX script development for file to stage layer by not using ETL tool.
• Understanding the data and finding the respective joins and master and dimension table. Pull the data by reducing the complexity.
• Worked as a solution architect for performance issue and new design approach.
• Mapping enhancement for production SR and IR.
• Unit testing, Unit test case document preparation.
• Adhoc mapping development for one-time load.
• Fixed the Performance issue in some of the ETL code and SQL.

Environment: Informatica powercenter 9.6, Data Quality, Oracle 11g, Green plum, Appworx, Windows XP, UNIX, Flat Files.

Confidential, Cary, NC

Technical Lead

Responsibilities:

• Eservice is one of the downstream applications which will surface the Confidential contract information and daily transaction. Application will display the data in form of drill down and drill up.
• Understanding the Legacy and Eservcie downstream application and data flow.
• Gather requirements from stakeholders including business subject matter users and IT teams
• Document data migration requirements, including source system analysis and source to target
• Communicating/Connecting the BRD and development team with proper process flow and mapping document.
• Involved in requirement gathering and channeling the envestnet data to Eservcie application.
• Involved in Preparing HLD, LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation.
• Working with Informatica power Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• ETL design performed using various informatica powercenter transformations like Source qualifier, expression, router, normalizer, various kinds of lookup’s like connected, unconnected, lookup’s.
• Running the status call to the business and follow up on open question to the business and solution team.
• Troubleshoot and resolve data/code issue related with ETL components
• Responsible for project delivery of the data masking program with a team of 7 members.

Environment: Informatica Powercenter 9.6, IDQ, MDM, DB2, Oracle, Flat Files, Windows XP, UNIX.

Confidential, Los Angeles, CA

Senior Informatica Developer

Responsibilities:

• Involvement in requirement gathering with customer.
• Troubleshoot and resolve data/code issue related with ETL components.
• Developing Informatica mappings and workflows for extracts and feeds. Data is extracted through mappings from different sources like Relational database tables, VSAM files, etc
• Involved in Government DHS Encounter submissions of 837I, 837P and NCPDP.
• Using B2B - Data Transformation Studio enables you to import and easily customize prebuilt transformations for industry standards such as EDI, SWIFT, and HIPAA.
• Using B2B, for 837 EDI files are comply with industry standards and regulatory requirements in real time
• Involved in writing UNIX shell scripting for moving the mainframe vsam file land zone to informatica source folders.
• Used shell scripting for breaking the files into small blocks for improving performance.
• Working with Informatica power Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• ETL design performed using various informatica powercenter transformations like Source qualifier, expression, router, normalizer, various kinds of lookup’s like connected, unconnected, dynamic lookup’s for SCD type 2.
• Used workflow manager for creating various tasks like session, event wait task, and command task.
• Designed ETL processes for optimal performance.
• Met Business demands by having direct client interactions, resource management, requirements gathering, analysis, design, development, change control and Implementation.
• Exceptional background in analysis, design, development, customization, implementation and testing of software applications and products in all phases of the system development life cycle (SDLC)
• Worked with application managers to prioritize the support issues from different applications and multiple projects in getting them resolved and implemented within SLA.
• Analyzing the requirements and making functional specification by discussing with business user groups and translate the Business Requirements and documented source-to-target mappings and ETL specifications.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Worked on command tasks, event wait tasks, event raise tasks, timer tasks to implement business logic

Environment: Informatica 9.1, Oracle 11g, Windows XP, UNIX.

Confidential, Eagan, MN

Senior Informatica Developer

Responsibilities:

• Involved in Government DHS Encounter submissions of 837I, 837P and NCPDP.
• Involved in building the data warehousing for maintain the policy information with snowflake schema.
• Involved in creating dimension and fact tables.
• Involved in System analysis, design, development, Data Warehouse/Data Mart design, RDBMS.
• Strong in Reading and Writing XML through Informatica.
• Involved in preparing XSD design and development using ALTOVA XML SPYWARE.
• Involved in using XML Parser and XML generator transformation in Informatica.
• Involved in using XSD design for various functionality like nodes, elements, complex type, and sequence occurrences like minimum and maximum occurrence for data elements.
• Worked with Source Analyzer, Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse
• Working with Informatica power Warehouse Designer, Transformation designer, mapping designer and Workflow Manager to develop new Mappings & implement data warehouse.
• ETL design performed using various informatica powercenter transformations like Source qualifier, expression, router, normalizer, various kinds of lookup’s like connected, unconnected, dynamic lookup’s for SCD type 2.
• Created Parameter files to pass database connections, parameter entries for source and target
• Involved in Internal submissions like BHI, CRIB and Inovalon Submission for HIX project.
• Involved in 24/7 production support for various ETL jobs (Informatica and Talent tools).
• Lead the development team and co-ordinate the projects among the developers

Environment: Informatica 9.1, Teradata, BTEQ, Talent, Oracle, Windows XP, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Created database objects such as tables, views, stored procs, functions in Oracle
• Involved in ETL design, coding, testing and implementations.
• Designed ETL processes for optimal performance.
• Created test cases and test scripts to validate data
• Tuned the performance of complex Informatica mappings and database.
• Worked with cross functional teams to resolve the issues.
• Created slowly changing dimensions & Fact tables to meet the business requirements.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Performed data validations.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.
• Created complex queries, procedures, and functions in SQL Server.
• Performed Root cause analysis and resolved complex issues.
• Created SQL Queries to validate the data in both source and target databases.

Environment: Informatica, MS SQL Server, IBM COGNOS, UNIX, Windows XP.