Software Engineer Customer Service

AFSAR AHMAD

***** ****** **, **. ***** – ***** MO

Phone: +1-314-***-**** E-mail: adwjuz@r.postjobfree.com

Objectives:

Working as a Software Ass. Manager at Accenture, US Delivery Centre, I am looking for challenging opportunities to use my knowledge & skills

Profile Summary:

13+ years of experience worked with Client as a Data Integration Lead, Solution Architect and Tech Lead with strong emphasis in business intelligence data warehousing, DW/BI, DM, OLTP, data quality, data governance, data modeling, metadata management and ILM technologies.

Consistently exceed project goals and customer service expectations.

Experienced in handling international client accounts in Healthcare, Pharmaceuticals, Banking, Insurance, Telecommunication and Retail.

Functional/Technical Profile:

Data Mart (DW)/Data Warehousing (DWH) Design.

Extensive knowledge in design of OLTP, ODS and EDW

Data Integration (DI) and Extract Transform and Load (ETL)

ETL Design / ETL Performance Tuning

ETL tool: Informatica power center 10.x/9.x

Data Quality: IDQ

Reporting tool: Tableau

Data Modeling: Erwin

Data Modular tool: Erwin Data Modular, Toad

Operating System: Windows, Unix, Linux

Data Base Tools: Toad, DB Visualizer, Teradata, SQL-Developer

Languages: Oracle SQL/PLSQL, UNIX Shell, Python scripting

Scheduler: Control-M, Autosys, Crontab

Code check in tools: ClearCase, VSS, Subversion, Microsoft Visual Studio

Working With:

Working with Accenture US LLP Client’s as Solution Architect, Technical Lead, Data Integration Lead roles from May 2010 to Till Date

Employer Name

Accenture India Pvt. Ltd, India and US both

Clients

i.BCBSLA, Baton Rouge

ii.Ascension Health, St. Louis

iii.JP MORGAN CHASE & CO, Chicago

iv.Pfizer Inc, New York

v.Bristol Myers Squibb, New York

Level

Software Ass. Manager

Roles & Responsibilities

Performed Solution Architect, Technical Lead, Data Integrator Lead roles for the new implementation, enhancement and support projects.

Managed teams responsible for end to end delivery. Provides supervision and technical guidance to the development teams, QA staff and business users.

Data architecture, conceptual documentation and data modeling experience

Experience in Informatica, Oracle, Teradata, ETL implementation, data cleanup procedures, transformations, scripts and data loading from various sources into Data warehouses and Data Marts.

Performed design specifications, functional and technical documentations reviews. Involved in analysis, planning, implementation and rollout.

Following, developing and implementing standardized data management policies and procedures and in achieving data management compliance with base regulations.

High-level data architecture conceptual documentation experience (Functional design document, source target mapping, Information Architecture diagram, Data E2E Flow Diagram, Ervin, Informatica).

In depth knowledge of data modeling and experience in creating conceptual data model and converting the same to logical data models and to physical database designs in Data mart/Data warehousing/OLTP Environments.

Established a global team. Responsible for people/ project management, skill & competency management, resource utilization, career and successor planning.

Monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters.

Involved in Pre-sales support activities including talking/making presentations/demos to clients/prospective clients for Business Development and Revenue Generation.

Managing Account/Leading supervising team onshore/offshore Model.

Responsible for client management, account management, relationship management and vendor Management.

Possess strong client facing skills and delivery, focused and Proficient in managing Cross-functional teams/projects.

Proficient with Onsite and Offshore delivery model and methodology.

Excellent verbal, interpersonal and leadership qualities.

Start Date

May 2010

End Date

Till Date

Period

9 years and 3 Months (India and US combined experience)

Employer Name

IBM INDIA PVT LTD, Bangalore, India

Clients

i.Pfizer Inc, New York, US

ii.American Express, Phoenix, US.

Level

Tech Lead/Architect

Roles & Responsibilities

Tech lead offshore team for 10+ members coordination with the onshore functional lead to get the tasks done within the specified time lines.

Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, database design and ETL specifications.

Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.

Worked on Informatica Power Centre Used Source Analyzer and Warehouse designer to import the source and target database schemas and the Mapping Designer to map the sources to the target, Mapplets and Transformation Developer.

Developed standard and reusable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.

Scheduled the Informatica & PL/SQL jobs scripts for different processes using the AutoSys scheduler.

Data validation scripts as per user's requirements.

Interaction with user and Involved in requirement gathering, prototyping and prepared various documents like Requirement Document, Integration plan, Unit test plan, Release notes etc.

Start Date

Oct 2008

End Date

April 2010

Period

20 Months

Employer Name

Wipro Technologies Bangalore, India

Clients

i.Walmart Stores Inc, US

ii.CISCO INC, San Jose, California.

Level

Senior Software Engineer

Roles & Responsibilities

Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.

Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, and Mapping Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Involved in developing source to target mappings and scheduling Informatica sessions.

Handling the change requests and completing it on time.

Prepared Unit test cases & Unit testing.

worked in Oracle SQL, Query performance tuning, Created DDL scripts.

Interaction with user and Involved in requirement gathering, prototyping and prepared various documents like Requirement Document, Integration test plan, Unit test plan, Release notes etc.

Start Date

Jun 2007

End Date

Sept 2008

Period

16 Months

Employer Name

Sasken Network Engineering Bangalore, India

Clients

Nortel Telecom

Role in Project

Trainee/Software Engineer

Roles & Responsibilities

Design Logical/Physical Data Model with meeting all business requirements.

Informatica Designer tools were used to design the source definition, target definition and transformations to build mappings.

Used Source Analyzer and Warehouse Designer to import the source and target database schema, and the mapping designer to map source to the target

Used Transformation Developer to create the joiner, filters, router, Expression and aggregation transformations that are used in mappings.

Creating Workflows Creating the Mappings & Transformations

Validating the Mappings, Generating & Loading the Data

Extraction of Data from different source.

Developed various Mappings

Creation of Stage mappings.

Developed mapping for data loading.

Test mapping to assure that data is loading as per ETL specification.

Data validation scripts as per user's requirements.

Preparing the ETL documents & Mapping Specification as per the DATA MODEL.

Prepared Unit test cases & Unit testing.

Start Date

May 2005

End Date

Aug 2006

Period

16 Months

Detail Working Experience:

Working with Accenture US LLP as Software Ass. Manager (Feb 2014 to Till Date)

Worked with Accenture India Pvt. Ltd, Bangalore as Technical Lead (May 2010 to Jan 2014)

Worked with IBM India Pvt. Ltd, Bangalore as Tech Lead/Architect (October 2008 to April 2010)

Worked with Wipro Technologies, Bangalore as Senior Software Engineer (Jun 2007 to September 2008)

Worked with Sasken Technologies, Bangalore as Trainee/Software Engineer (Oct 2005 to May 2007)

Educational Qualifications:

B.E in Electronics and Communication from Maulana Azad College of Engineering & Technology affiliated to Magadh University, Bodh Gaya, Bihar, India (Aggregate Percentage-72% First Class with Distinction)

Date of Birth : 29-Jan-1978

Work Authorization: Green Card holder

Contact this candidate