M Athar Ali-Business/Technical Consultant CV contact:
[email protected]
Objective: To utilize my business and performance management skills in business
intelligence, data warehouse and database projects to effectively capture business requirements. Subsequently utilize my technical skills to design, develop and implement solutions to meet those business requirements.
Professional Overview:Athar is a Business/Technical Consultant with more than 5
years experience in capturing business requirements, analyzing, designing, and implementing enterprise class business intelligence, data warehouse, business rules engines and database applications. Athar has strong leadership, project management and technical skills and has led teams of Business Analysts and Software Engineers. He has experience in Project management and instituting CMMI level 5 processes.He has excellent communication skills. During his multiple client engagements, he has worked both as business and data analyst.
Keywords: Business Rules Engine, Business process, Business Process Redesign,
business requirements gathering, fund asset management, online advertising, performance management, project management, data analysis, SQL, PL/SQL, SQL Server, Sybase, Oracle 9i/10 g, OLAP, DB2, IMS DB/DC, MS Access, Aqua Studio, data migration, data profiling, data quality, Microsoft Visio, multi-dimensional data modeling, star schema, entity-relationship modeling, normalized modeling, Erwin data modeler, data source metadata, agile methodologies, JAD, full life-cycle SDLC, Operational Data Store (ODS), Data Warehouse, DataStage, iterative development, one-on-one user interviews, surveys, project proposal documentation, presentation skills, SPSS, CMM/CMMI, supply chain, disaster planning, emergency management, risk management, Cognos Report Studio/Event Studio
Roles
• • • •
Business Analyst Data Analyst Database Designer / Modeler ETL Developer
Solutions
• • • • •
Business Intelligence Data Warehouse Database Business Rule Engine Risk Management
Industries
• • •
Financial Services/Asset Management Online Advertising Defense
Technologies
• • • • •
IBM DataStage Cognos BI 8 Report Studio Oracle 9i/10 g, DB2, SQL Server 2005, Sybase SQL, PL/SQL Microsoft Visual Source Safe, SVN
• • •
UNIX Erwin Data Modeler, Oracle Designer TOAD, SQL Server Management Studio
Key Professional Engagements • •
• • • •
Deutsche Bank
Business Analyst, Data Analyst and DBA (1 yr 10 months)
• • • • • • • • • •
Interview business users and Subject Matter Experts (SME's) to gather business requirements Analyzing and documenting business documents/ use case analysis/ swim-lanes / sequence diagrams / component diagrams to extract functional and non-functional business requirements in collaboration with business users and SME's Gap analysis and redesign of existing business processes to make them more efficient for automated processing Documenting as-is business processes with emphasis on financial performance management Analyzing as-is business processes and recommending performance indicators for to-be business processes Documenting the to-be business rules to be implemented in collaboration with the business Design and implement the data layers requiring data architecture skills for business rules engine Translating business requirements into data layer requirements Designed and implemented multi-dimensional modeling design using dimension and fact tables in a star schema design Source data analysis and data profiling and qualification, data validation and verification data integrity identification and resolution in collaboration with the owner of the data source, data quality Creation and management of the Sybase and MS SQL Server databases Data Migration for business processes from spreadsheets into database Database release management in UAT and Production environments interfacing with the application development team Participated in Quality Assurance testing as team member Conduct training sessions with business users as well as other members of technology team
Accomplishments: • Automated 40 business processes for fund asset management group • Extra-mile award winner • Volunteered as DBA and helped save the client personnel costs
•
Cars.com
ETL Developer (5 months)
• • • •
Key member of the data warehouse team in a multi-phase effort to draw at least thirty percent more traffic to the web site Analyze the business requirements Translate business requirements into technical specifications Develop ETL programs in DataStage to meet requirements to load data in Operational Data Store (ODS) after cleaning and transformation Develop Shell scripts to integrate and execute various modules
• • •
Development, Code-Walkthrough and code-review for DataStage code components Development code unit testing and quality assurance Develped a process to improve the quality of deliverables for the development team including other Datastage developers.
Accomplishments: • Substantially increased quality assurance by reducing defects of DataStage code deliverables
• • •
Purdue University
Research Assistant (1 yr 7 months)
• • • •
Research assistant with Cognotive laboratory and the famed CERIAS security labs at Purdue Research the usability issues associated with user privacy Identifying problems and documenting and presenting feasibility reports to laboratory faculty Conduct user interviews and surveys to understand user awareness of privacy issues Design and conduct experiments on the user group Analyze the data collected and present findings Present findings at workshops and conferences at Purdue and other universities
Accomplishments: • Published research in respected Human-Computer Interaction science journals • Invited to present research at Carnegie-Mellon
HSBC
BAE Systems
Sr. Data Analyst (1 yr 6 months)
Consultant (1 month)
• • •
Led a team of data analysts and developers for loan products Instituted CMMI Level 5 in the project create ad-hoc and other reports
Accomplishments: • Project earned CMM-5 Level in less than half-the industry standard time
• • •
Interviewed senior management Developed and presented a risk management solution to senior executives Developed a disaster management plan
Education • MS, Purdue University,United States 2006 (Computer Technology) GPA 4.0 • Bachelor of Engineering, REC India 2002 (Mechanical Engineering) Passed with Distinction
Professional Training/Certifications
• • •
Cognos 8 Report Author certified DataStage training CMMI, CMM-5