SUMMARY:

• I have a valid US work permit (EAD Card) on L2 visa and don’t require any form of visa sponsorships.
• 11.5+ years of total IT experience in Solution Design, Data Modeling, Data Integration, Data quality, System and Impact Analysis, Business Intelligence and data ware housing Concepts. Currently working as a Project manager in Confidential.
• 8+ years of Data warehousing ETL (Extract, Transform, and Load) experience using Informatica 8/ 9 Power Center, Teradata SQL concepts and load utilities, Oracle, including complete System Life Cycle from Analysis and Design to Implementation and Support.
• Around 4 years of experience in Business Objects reporting, Dashboards, Micro strategy reports
• Worked in Life Science, Insurance, Retail Domain projects
• Worked as BI Technical and business Analyst for Confidential, Life science client at UK client office for 2 years.
• Worked on high end dashboard projects of market trending and financial projections on Ipad to the top Business officials including CEO during my onsite tenure.
• Has provided technical and process related response to new clients and deals by understanding the current business requirement and latest market trends.
• Received “On the spot award “for the third quarter of 2009 from Confidential Technologies Limited for excellent work done in the Project.
• Received ‘Insta leadership award’ at the organization level for team management in 2011.
• Teradata V2R5, Informatica certified. Quality and process related internal trainings/certification at Confidential .

TECHNICAL SKILLS:

Database: Teradata, Oracle

Tools: Informatica, Business objects - reports and dashboards, Micro strategy Has basic knowledge on Mainframe - COBOL, JCL, CICS

PROFESSIONAL EXPERIENCE:

Confidential

Techinal lead and business Analyst

Responsibilities:

• Has worked on most critical and high end ipad applications for Executives.
• Client facing single point of contact for certain key applications from development, enhancement .
• Continued in the project from offshore post my return from onsite.
• Meet with business stakeholders, SME and other technical team members to gather and analyze application requirements.
• Formulate Principles & Guidelines that forms the core of the existing Landscape. Exercise Impact assessment of the system and its performance.
• Discuss with Enterprise Architect’s team and other eco system partners to review and finalize the architecture of any new development /enhancement.
• Coordinate with the Customer, Vendors & Confidential offshore team to design, support and enhance the Confidential systems.
• Analyze the source system and perform comprehensive data analysis, Design data model or in corporate additional changes in the data model to meet business requirement.
• Design Data acquisition and Data Integration and reporting Strategy
• Design of mappings, workflows in Informatica. Create or modify the BO reports and dashboards. Testing them from business requirement perspective and performance on the landscape.
• Handled capacity planning and system integration activities.
• Daily updates to customer. Daily, Weekly and Monthly updates to Governance
• User on boarding process and the support on the new development / enhancement.
• Managing the Service Enhancement Request and landscape Rationalization to bring in optimization.

Environment: Informatica, Oracle, Business objects, xcelcius, Sharepoint

Confidential

Technology Analyst

Responsibilities:

• Data profiling was key in this project as this was a major merger program.
• Responsible for Business Analysis and technical feasibility on the source systems to get the business rules.
• Data modeling to the new source system as per EDWard standards.
• New Mapping, workflow, scripting creations.
• Data cleansing mappings to bridge the source systems with the existing EDW.
• Historical data loading and testing using the new workflows created in EDWard.
• Responsible for code review, preparing the design document etc.
• Contributed in effort, timelines and cost estimation for the modules handled.
• Coordination with Onsite team, developers, Quality Assurance team and testing team.

Environment: Informatica, Teradata, Version control Vss.

Confidential

Technology Analyst

Responsibilities:

• Data profiling of the source data from various source system. Business and Impact analysis on the Source data available.
• Solution design for data cleansing and data integration from various sources to pharmacy staging environment and then to transformation layer and Business layer and then to EDW layer.
• Necessary DB objects, mapping, transformations, workflow session generation to meet the business expectation. Performance tuning concepts factored during design phase.
• Responsible for mentoring, tracking, task allocation for a team.
• Responsible for Mapping document preparation, code review, preparing the design document, testing requirement etc.
• Contributed in effort, timelines and cost estimation for the modules handled.
• Coordination with Onsite team, developers, Quality Assurance team and testing team.

Environment: Informatica, Teradata

Confidential

Senior Software Engineer

Responsibilities:

• Coding, Unit testing, review, Test plan, Test results review.
• Onsite/offshore co ordination, Guiding and mentoring the team in design, coding and testing.
• Coordination with QA and ensure that testing is done and defects are tracked to closure
• Participating in project meetings as necessary
• Providing a weekly status report

Environment: Teradata, Teradata SQL assistant, IBM MAINFRAME,Microstrategy

Confidential

Software Engineer

Responsibilities:

• Analysis and Impact assessment of the business requirement.
• Feasibility to build the requirement based on the available data in the marts.
• Design additional feeds or data cleansing from the source data if not readily available.
• Design the new report layout and the parameters, attributes, filters, prompts that is required for new reports.
• Coding, Unit testing, review, Test plan, Test results review.
• Onsite/offshore coordination, Guiding and mentoring the team in design, coding and testing.
• Participating in project meetings as necessary
• Providing a weekly status report

Environment: Microstategy, Teradata, IBM MAINFRAME

Confidential

Software Engineer

Responsibilities:

• Analysis of existing unit, Prototypes for the various sotwares and coding and testing of the prototypes