Associate consultant Resume

SUMMARY

Trained and certified professional with experience in building and supporting large scale projects for the top players in the market.
Expertise in translating business requirements into viable technical solutions
Participating in the conception of high level technical design and contributing to the design review team within the organization
Driving large teams and aligning the resources to provide effective enterprise wide solutions in a fast - paced agile environment.
Good verbal and written communication skills that help in communicating effectively with stakeholders across the project.
Ability to successfully participate, perform and contribute effectively in multiple projects simultaneously
Experienced with working in a fast-paced delivery environment with tight schedules and remotely located teams

TECHNICAL SKILLS

Programming languages: Core JAVA, SQL

ETL: Informatica 9.1 power center

OS: UNIX, Windows

Scripting Languages: XML, and HTML.

Ticketing Tools: BMC remedy user, ServiceNow(Snow).

Development Tools: Eclipse, Net Beans, Teradata, TOAD

Version control tools: SVN.

FTP tools: WINSCP,PUTTY.

PROFESSIONAL EXPERIENCE

Associate consultant

Confidential

Responsibilities:

Reviewed database business and functional requirements, reviewed mapping transformations
Worked with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issues with requirements/mapping transformations
Created Test Plans and test scripts, executed test scripts, and wrote Test Report
Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
Extensively used SQL queries for data validation and backend testing.
Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
Played role in creation and testing of designed scalable, reusable, and low maintenance ETL templates.
Creating the expected results by executing the queries according to the test conditions.
Raising defects where discrepancy found in the database and reporting it to the onshore development team.
Guiding new resources to make them familiar with the project work

System Analyst

Confidential

Responsibilities:

Deciphering the issues reported by the clients in the issue management/ reporting tool and receiving the necessary information to resolve the issue from the client’s end.
Formulating solutions for the issue at hand swiftly, yet ensuring that the standards set for issue resolution, SLA and the defined architecture are adhered to.
Collaborating with other stakeholders in the project during issue resolution
Creating the necessary resources for the issue resolution by establishing specifications, test cases and the change management documentation
Validates results by testing programs.
Setting up workshops for business users when necessitated to onboard them on release changes and communicating the process level changes, if any.
Authoring design and implementation related artifacts
Aligning the deliverables to the scope of the project and the client’s expectations
Participating in agile meetings and reporting on the status of deliverables slated for the current sprint
Performing an impact analysis of solutions formulated and presenting the observations to the scrum team ahead of major releases
Leading the o level 3 support team working round the clock

Senior Software Engineer

Confidential

Responsibilities:

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into the targeted database
Understanding the Requirements and designing the process architecture.
Implementing complex mapping to Extract, Transform and Load data from source to target system using Power Center of Informatica.
Implementing UNIX Shell scripts for the purpose of Data Quality check on the files received by client. The checks include the waiting for a signal file (like file watcher) to signal the reception of the actual data file, checking on filename naming standards, date on filename, record count of file and delimiter count inside the file. If every check is validated according to the standards, then triggering the corresponding Informatica workflow.
Creating reusable transformations and mappings using Designer Tool set of Informatica.
Preparing Unit Test Case and Peer review docs for system testing
Working with the business team and the data analyst to design and implement the flow of data into the enterprise warehouse
Translating business requirements into data models
Supported by offering expert technical advice when debugging and troubleshooting data issues in performance and scaling
Responding within the stipulated SLA to incidents reported
Resolving critical incidents reported by the client independently
Working with a geographically spread out team across various time zones