A Shaik

Bethlehem, PA *****

ac8dz0@r.postjobfree.com 408-***-**** www.linkedin.com/in/afraz.shaik

Senior BI Consultant

Analytical IT Professional Recognized for Team Collaboration to Achieve On-Time Project Delivery

IBM Certified Cognos Designer

Leverage BI Reporting environment and business acumen to fully assess operational needs and develop requirements that drive quality development efforts. Proven expertise in all stages of SDLC, project methodologies, design, development, testing, and implementation. Comprehensive experience with dimensional and star schema data modeling. Lead team collaboration with excellent communication skills. Diverse sector background includes financial, health insurance, educational, pharmaceutical, media and entertainment, real estate, call center, product-based and mining industries, transportation, automotive, consulting, and sports. Fluent in English, Hindi, Telugu, and Urdu, and basic Tamil.

Technical Skills

Languages:

SQL, Python, Java Scripting, C, C++, Shell Scripting

Operating Systems:

Windows, Unix

Python Libraries:

NumPY, Pandas, NLTK, Matplotlib, Seaborn, Scikit

Version Control Tool:

SVN, GitHub

Development IDE:

Anaconda (Jupyter, Spyder)

Machine Learning Algorithms:

Supervised Learning- Linear Regression, Logistic Regression, Decision Tree, SVM, kNN, K-Means, Random Forest

Methodologies:

Agile, Waterfall

Databases:

DB2, Oracle, Toad, SQL Server

BI Tools:

Cognos, Tableau, Framework Manager, ETL (Data Stage), ESRI Maps, Query Studio, Analysis Studio, Event Studio, Brio Tool, Metric Studio, Cognos Administration, Access Managerl

Others:

Self-Trained on Data Science, Tableau, Python and MDM ( Digital Insights)

Professional Experience

IBM, Columbus, OH 01/2014 – 08/2018

Sr BI Cognos Developer

Delivered end-to-end reporting solutions for large, complex, multiple-site projects. Exercised comprehensive technical experience in variety of platforms and industries. Oversaw portfolio in all stages of SDLC and maintained best development strategies during execution of requirement gathering, design, maintenance, and testing. Served as BI consultant that supported multiple global and offshore projects.

Clients : CMS (cognos consultant), OCC (ETL tester), Golf Now (cognos developer), Michelin (cognos lead),

Integra Life Sciences (cognos developer), DIRECTV (cognos lead), Jones Lang Lasalle (cognos developer),

Northwestern Mutual Life Insurance (cognos developer), Joy Global (cognos developer)

Roles : BI Consultant / Developer / Admin)/ ETL tester / Business Analyst / SQL

Tool Versions : Tableau, Cognos V11.9, V11.6, V11.5, V11.01, V10.2, V10.1, ETL – DataStage, Data Studio, WinScp

A Shaik ac8dz0@r.postjobfree.com Page Two

IBM (Continued)

Received “IBM Best Employee Reward for Best Performance,” increasing center’s accountability and profitability 10%, spearheading multi-tasking, P.O.C project-effort estimations, and leading and coordinating with teams and developers.

Collaborated with BA in user-requirement gathering and consolidation of cognos requirements, design, and development.

Delivered troubleshooting excellence in dataflow, audit, system, health check, performance, CDC (Type 3), and user-acceptance testing for ETL Data Stage deliverables.

Performed metadata modelling and data-level securities, adhoc package, determinants, cardinality (joins), filters, calculated fields, DMR dimensional modelling, Star Schema, Snow Flake schemas using Framework Manager tool.

Oversaw authentication and authorization of user accounts and groups, employing Access Manager, Version1 and Control M Scheduler tools.

Worked on Performance Tuning of queries and reports, Views, Materialized Views, handling Blob Data Sets, Special Characters, Macros, Prompts in Cognos.

Represented IBM in consultant role, conducting client / user training sessions, deploying, scheduling, monitoring reports, writing complex SQL queries and Managing Offshore teams.

Participated in splitting the data into training set, test set and scaling data in training set and test set, if necessary

Involved in Data Science Project to create Statistical algorithms involving Linear Regression, Logistic Regression, Random forest, Decision trees, Support Vector Machine for estimating the risks through Python.

Incorporated in developing statistical models to forecast inventory and procurement cycles.

ALLIANCE IT, San Jose, CA 01/2012 – 12/2013

BI Developer / Tester (Cognos Developer/Admin, Business Analyst, Tester)

Promoted to lead developer based on contributions made while overseeing BI development, requirement customization, and implementation. Attained high-profile role in development and testing teams.

Clients : Afinion Group (Cognos Developer), HAP (Cognos Lead), Eaton Corporation (Cognos Admin)

Roles : BI Developer / Admin / Business Analyst / SQL/ ETL DataStage Tester

Tool Versions: Cognos V10.2, V8.4, V8.3, WinScp, Unix, DataStage

Designed and developed reporting solutions across multiple releases, including consolidation of requirements, designing wireframes, ad-hoc package, dashboards, map manager, score-carding and visualizations.

Served as internal SME for use case modeling, gap analysis and impact analysis, executing proficiency in RDBMS relational databases.

Provided respective project managers with effort analysis and estimations, including time and resources.

Represented as a consultant role, conducting client / user training sessions, deploying, scheduling, monitoring reports, writing complex SQL queries and Managing Offshore teams.

Manually tested the data for DataStage Input and output source files through creating and monitoring DataStage jobs.

Documented the ETL DataStage deliverables.

A Shaik ac8dz0@r.postjobfree.com Page Three

KSIT, Columbus, OH 08/2011 – 12/2011

Cognos Developer

Pioneered specific expertise in bi-reporting, testing, and performance tuning to deliver technical expertise in achieving optimal solutions.

Client : ING Direct

Tool Version: Cognos V8.4

Applied determinants functionality, user global filters, macros, calculations, alias tables, and hierarchies on FWM package (DMR dimensional modelling), eradicating ambiguous issues.

Created drill-through, drill-down, master-detail relationship, conditional formatting and blocks, Java scripts, and render variables, hiding / showing dashboard and report contents.

ITU, San Jose, CA 02/2011 – 05/2011

Tester

Served as intern while obtaining master’s degree to manually test user-interface applications.

Enhanced test plan and project-status tracker templates, adopting changing customer requirements and standards.

Spearheaded debugging and investigation of user-raised issues, resolving and porting concerns and defects.

Education and Certification

Master of Science (MS), Computer Engineering, International Technological University, San Jose, CA, 2011

Bachelor of Technology (Btech), Mechanical Engineering, JNTU, India, 2009

IBM-Certified Cognos Designer

Contact this candidate