Asim Baig
Gurnee, IL *****
Cell: 571-***-****
E-mail: *********@*******.***
Summary
Reputable team leader and savvy solution consultant to clients including retail giants, in surance firms and
automotive leaders with over 9 years’ experience in project execution, implementation of HR business solutions,
custom configurations, quality assurance and team coaching.
Skills:
More than 9 years of experience as Lead System Analyst/B usiness System Analyst
Experience in Project Management and System Analysis and Design.
Proven team player with a good deal of working experience in teams during different projects.
Technical Consulting
Solution Delivery
Project Management
Requirements Gathering
SQL Development
Quality Assurance
Technical and User Documentation
Team Development and Mentoring
Technical Proficiencies
ETL Tool Informatica, SAS
Languages SQL, T-SQL, PL/SQL, XML, C, C++, VB
Databases MS-SQL Server, Oracle, MS Access, MS Excel, DB2
Operating System W indows 2000/2003/XP/7, Mainframe skills (ISPF, Control M, File Aid, JCL)
Testing Tools Win Runner 7.6, QTP 8.0, Test Direct 8.0
Work Experience
May 2012 – Now
Lead Systems Analyst
AON HEWITT IL,USA
Owns the Overall Load Process which includes designing the load process, technical project plan
and quality assurance (data loaded matches requirements).
Reviews maps (analysis and construction) for accuracy/efficiency and reviews DA documen tation
for maps and/or new process for their specific client.
Reviews functional specifications from the Conversion Manager and embellishes and/or refines the
technical specifications that are necessary for the DA to be able to code the conversion maps
Implements SDLC methodology at an advanced level for other team members and monitors
adherence to SDLC for client team.
Assesses scope changes and delays; works with DCM to identify impact on overall milestones and
Project's staffing needs.
System Construction and analysis on client's requirement. Coded accurate and efficient maps in
Informatica Designer based on client's requirements.
Data Analysis using Informatica data profiling tool, Cognos and SQL to make customize reports for
clients.
Performed data analysis on complex requirements using problem solving skills.
Coordinated the client team work, monitored task completion, and communicated team schedule
and made sure tasks completed on time.
Reviewed Analysis and Test Plan documentation updates made by oth er Data Analyst and
evaluated the results of the test plans execution.
Coached new associates on technical tools such as Informatica Designer, Workflow Manager,
W orkflow Monitor and AQT (Advance Query Tool).
Asim Baig
Processed and validated data in system, including running Informatica maps, jobs on Mainframe
and writing advance SQL queries to verify results.
May 2005 – Apr 2012
Systems Analyst/Business Systems Analyst
AON HEWITT IL, USA
Followed the SDLC to gather requirements, analyze, configure/design and test prior to releasing
major functionality in HR business application portal to external clients.
Adhered to the formal change management processes to ensure highest quality before deploying.
Coached and mentored various teams on configuration, testing, and defects (identifying and
debugging) to name a few.
Configured the system to meet analysis specifications, documents relevant configuration in analysis
specifications and fix any issues identified via test execution for various client teams .
Successfully delivered and maintained fully functioning benefits system for the client team and
ensured that all issues are resolved before going into client system.
Conducted Resolution and Debugging of Issues and utilized the relevant problem -solving resources
as needed and escalated issues when appropriate for Client and other teams.
Used SQL, Mainframe, DB2 and Quest to prepare and deliver on time client's reports
Aug 2004 – Dec 2004
QA/Programmer Analyst
TEKSTROM INC. DE,USA
Assisted in Developing test matrices to trace scenarios, requirements and Product
Component
s to appropriate test scripts.
Developed Scripts in QTP and W in Runner to perform Functional and Regression testing.
Extensively used data parameterization, GUI checkpoints, database c heckpoints and
synchronization statements.
Enhanced the scripts by inserting checkpoints and solved the synchronization problems
using the synchronization points.
Verified calculated Results using spool Tables, an SQL scripts that queried all thee tables in
the report database and spooled the data to comma delimited test files.
Compared the data from two text files using lists of records.
Mar 2003 – Aug 2003
Systems Analyst/Database Developer
RELAPOINT COORPORATION. NE,USA
Support the Data Modeling unit with the design of new databases to meet application
W rote database triggers and stored procedures.
Created forms and done a lot of PL/SQL programming according to the client specifications.
Responsible for developing reports of standard type as per th e client requirements Creating
tables and executing different SQL queries
Jan 2002 – Aug 2004
Teaching Assistant
UNIV OF NEBRASKA AT OMAHA. NE,USA
W hile working as Research/Teaching Assistant at University, involved in analysis & design
of different application software, Databases and analyzing/managing different databases.
Designed and programmed a database management application for Gerry’s DNATA
using Oracle, Developer 2000 and Visual InterDev.
Designing Loan Arranger System for Financial Consoli dation organization, FCO
Environment: Visual Basic and Microsoft Access
Education:
Master of Computer Science Aug, 2004
University of Nebraska at Omaha, NE, USA
Concentration: Database Management Systems