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