SUMMARY

• 13+ years of professional IT experience as Developer and Business Analyst in Retail, Telecommunication, Insurance and Healthcare domains .
• Strong data analysis skills along with domain knowledge/business understanding.
• Expertise in authoring Business requirements and providing functional specifications.
• Hands on experience in Defect Management using tools like HP ALM, JIRA, Rally .
• Experience in all phases of Software Development Life Cycle (SDLC) and Agile Methodologies.
• Good skills in Informatica, Python, Node Js, React, Oracle, Teradata, Unix, Snowflake and SAP.
• Good Knowledge on HDFS, Hive, SPARK, Aws services, Docker, Terraform, Airflow, Git etc.
• Created Hive queries for analysis of data and summarizing of data for report generation.
• Developed Stored Procedures to automate ETL processes.
• Experience in all phases of Software Development Life Cycle (SDLC) and Agile Methodologies. Experience in Dimensional Data Modeling, Slowly Changing Dimensions Type I & II, Star Schema /Snowflake Schema modeling, Fact & Dimension tables, pulling data from the Facts and dimension in the reporting layer.
• Strong data analysis skills along with domain knowledge/business understanding.
• Developing, Designing, Analyzing & Reviewing database objects - functions, stored procedures, cursors, triggers, views.
• Exceptional Ability to design & lead integration of tools or application with existing infrastructure, aiding complete business functionalities while reducing the Maintenance Cost.
• Project Management Skills - planning, cost & effort estimations, track schedules & delivery.
• Suave at dealing with internal and external customers. Skilled team player, with ability to drive the team to achieve required goals; mentoring as per needs.
• Working in Scrum, Sprint and agile mode.

TECHNICAL SKILLS

• Informatica Power Center 10.2/9.6/9.1/8.6 , Alteryx, Informatica IDQ (Beginner)
• Python, Hadoop, Spark, Hive, HBase, SnowFlake, PIG
• Docker, Terraform, Aws services, Node Js, Java Script, React
• Cognos, Tableau
• Teradata 13/12, Oracle 10g/9i, SQL server 2012, MS SQL
• Teradata SQL Assistant, TOAD, SQL Navigator, PLSQL Developer
• Agile and Waterfall
• Windows, Linux. Unix
• Autosys, Airflow
• FTP, sftp, iMFT, eMFT
• Unix shell scripting, Java, OOPS Concept
• CVS, Microsoft SharePoint, Git

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead

Responsibilities:

• Interact with other architect, design, and development teams to ensure operational standards and guidelines are considered and adhered to during the early phases of a project.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Assist in the development, design and implementation of application Components using SQL Assistance.
• Perform application systems development tasks which include working with users to define system needs, analyzing and designing applications to meet user needs, design and review Technical/Functional documents and provide sign off, preparing flowcharts and diagrams to illustrate logical sequence, translating logic diagrams into program statements using SQL, design Design, code, test and document programs.
• Coordinate development activities evaluate and report performance of project by Generating Business user reports to identify the overall success rate.
• Analyze and fix defects found by QA & Product owners and work closely with Quality Assurance Team to close out all open defects.
• Responsibilities included preparation of high-level design, Detail level design, code walk through for mapping and work flows, resolving technical and design issues and performing independent unit testing

Confidential

Developer/Technology Lead

Responsibilities:

• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Assist in the development, design and implementation of application Components using SQL Assistance.
• Perform application systems development tasks which include working with users to define system needs, analyzing and designing applications to meet user needs, design and review Technical/Functional documents and provide sign off, preparing flowcharts and diagrams to illustrate logical sequence, translating logic diagrams into program statements using SQL, design Design, code, test and document programs.
• Coordinate development activities evaluate and report performance of project by Generating Business user reports to identify the overall success rate.
• Analyze and fix defects found by QA & Product owners and work closely with Quality Assurance Team to close out all open defects.
• Responsibilities included preparation of high-level design, Detail level design, code walk through for mapping and work flows, resolving technical and design issues and performing independent unit testing
• Ensure integration is tested for business needs as per specs before solution is delivered
• Reduce the cost of defects with early and frequent detection and prevention
• Accelerate the pace of development and stability of code through a predictable and repeatable testing model
• Data validation in Teradata, Oracle, SAP BW, BAPI and IDOCs
• Co-ordination and Management of the work queue from a team of 3-6 members at offshore
• Driven completely from onsite, it also involved direct interactions with Line of Business across the upstream and downstream Interfaces. independently fixing issues, working on enhancements, servicing business changes from Analysis, Estimation, Design, Coding, Configuration management
• Identifying different and faster integration patterns.

Confidential

Technical Lead

Responsibilities:

• Ongoing systems administration operational support, upgrades, and configuration for power center.
• Interact with other architect, design, and development teams to ensure operational standards and guidelines are considered and adhered to during the early phases of a project.
• Create and customize scripts for automation of tasks.
• Requirement analysis, ensuring data quality, Providing end to end support i.e. from source extraction to target reporting, Resolving multiple issues which occur in ETL and also in the reporting end, Automation of data load, Implementing change requests and performing independent unit testing.
• Setting up the governance as multiple vendors were involved in development.
• Worked as Informatica admin and maintaining the system

Confidential

Technical Analyst

Responsibilities:

• Requirement gathering, analysis, design. Implementation and testing of new projects.
• Taking part in understanding the business requirements and creating business rules for mappings or new functionalities.
• Performance tuning of mappings, sessions for reducing the job times to load data in Data Marts.
• Handling the open tickets from open state, analysis, user approval, implementation in production till closure of tickets.
• Developed mappings in Informatica to Extract, Transform and Loading the data from various sources into the Data Warehouse using different transformations like Source Qualifier, Expression, Filter, Lookup, aggregate, Update Strategy, Router, Sequence generator and Joiner.
• Extracted data from various source systems like Oracle and flat files as per the requirements.
• Modifying the queries to use the feature for performance improvement.
• Involved in Design reviews & test cases reviews with clients.

Confidential

Technical Analyst

Responsibilities:

• Creating new mappings.
• Taking part in understanding the business requirements and creating business rules for mappings.
• Running and debugging mappings for errors.
• Creating load files and load into SAP
• Involved in independently fixing issues, working on enhancements, servicing business changes from Analysis, Estimation, Design, Coding, Configuration management.