Data Developer

Shirazi A. Siddiqui 215-***-****)

*******.********@*****.***

Working as a Data Science & Analytics Intern from Jan to till date at Aiir Consulting

Microsoft Azure Solutions Architect : Design and Architect end to end Analytics solutions using Azure Synapse Analytics,Data Modeling,Data integration, Data warehouse fact and dimension loads and creation of dashboards using embedded PowerBI as per end user/business requirements.

Technology used AWS for Aiir websites and databases : (AWS EC2, S3, KM, IAM,

Route 53 etc.).

LinkedIn Profile : linkedin.com/in/shirazi-siddiqui-80301356

PAST EXPERIENCE SUMMARY

• 12 + years of expertise in Data Warehousing & Business Intelligence (BFS/Healthcare domain). Experience in various phases of software development life cycle (SDLC).

• Informatica Power Center (ETL),Oracle (RDBMS), DB2, PL/SQL, power exchange, Unix Shell script, IDQ. Complex/advanced SQL queries and strong data analysis skills in RDBMS. Basic knowledge and data analysis skills in No Sql. HUE/HADOOP-Big data, Hive-HQLs, HDFS, Map Reduce, Edge node, Trifacta, Oozie etc.

• Extensive work experience in creating various database objects such as indexes, triggers, PLSQL blocks, stored procedures etc. and implemented various performance tuning.

• Good coding experience in Python( NumPy, Pandas, Seaborn, Matplotlib, TensorFlow etc.).

• Ability to work with sources of various formats like EXCEL, JSON, Fixed width and delimited files like CSV/TEXT etc.

• Strong in extract, transform, and modify data in preparation for statistical analysis and the creation of machine and statistical models and reports.

• Possesses Strong interpersonal, problem solver, communication skills, ability to make precise and solutions-oriented contributions and providing effective resolutions in highly demanding situations and work independently. Project Management and Advanced MS Excel proficiency.

Cognizant US CLIENTS Work Summary: 2010-2018

Worked as Technical/Team Lead at Kaiser Permanente at Colorado,USA/ Hyderabad, India for 4 years (2015-2018).

Worked as Application Architect/Team Lead at American Express at Phoenix, AZ,USA for 2 years (2013-2015).

Worked as Senior Application Developer at UBS, New Jersey, USA/ Pune, India for a year(2012-2013).

Worked as Application Developer (Individual contributor) at Barclays Wealth, New York, USA for a year (2011-2012).

Worked as Application Developer (Individual contributor) at Core Logic, Dallas, TX,USA for a year (2010-2011).

EDUCATION

Saint Joseph’s University Philadelphia, PA

Master of Science in Business Intelligence and Analytics Jan 2019 – Aug 2020 Accomplished 9 courses : Business Analytics, Data Vis & Perf Analytics (Tableau/Power BI), Found for Business intelligence & Analytics, Data Mining, Web analytics, DBMS, Predictive Analytics, Python and VBA. Last course “R statistical Language” will be done by Aug 2020.

University of Virginia Executive Certificate in Project Management Sep 2016-Sep 2017

Uttar Pradesh Technical University Lucknow, INDIA

Bachelor of Technology Jul 2001-Jun 2005

Work History

Cognizant Technology Solutions India Hyderabad, India

Senior Associate (ETL Technical-Lead) Jan 2016- Dec 2018

Technology/Tools used: Informatica Power Center, Oracle, db2, Unix shell scripting, Tivoli, Teradata and MS Excel.

• Onsite-offshore Coordination, Communication, requirement gathering and analysis, Design, development, code review and SIT/UAT/PROD support. • Project and People Management. (Hiring/Firing). Participated in Recruitment drive. • Guide team to understand the requirement, design and solve technical issues. • Coding Code Review, Unit Testing, Deployments and Creation of CRQs/WOs.

Cognizant Technology Solutions US CORP New Jersey, USA

Associate - Projects Apr 2010- Dec 2015

Technology/Tools used: Informatica Power Center/IDQ, Oracle, db2, Unix shell scripting, Scheduling tools: Control M, AutoSys, Tivoli, Big data: Hive - Hqls, Impala, Sqoop jobs, oozie, edge node, MS Excel etc.

• Onsite-offshore Coordination, requirement analysis, Design, development. Coding of specific modules like Tiversa, Experian. Guide team to solve technical issues. • Module Integration, Code Review, Unit Testing, deployments & SIT/UAT/PROD support. • Design/Implementation of data quality of External Sources and Internal sources. • Hive-hql, bash scripts in Edge Node, Sqoop jobs, java ftp program, views in Hive/Impala, Megastore/Hbase tables and various stored procedure in DB2 database. • CRQs/WOs/Adhoc runs & job scheduling by Control M.SFT setup for source files.

Cognizant Technology Solutions India Pune, India

Programmer Analyst Apr 2006- Apr 2010

Technology/Tools used: Informatica Power Center, Unix, Oracle and MS Excel • Production Runs, Monitoring Troubleshooting, Enhancement/creation of Mappings, sessions, Workflow management and automation. Performance Tuning Techniques • Interacting with the Client on various forums and Understanding existing system and client requirements. Preparation of source to target mapping design and documents.

Certificate completed through Cognizant

• Level 0_Big Data and Level 0 Data Analytics Enablement 2016 • Advanced SQL scripting (specialist) Certificate 2017 • SQL Certificate 2010 • Informatica mapping design & Admin/Architecture 2008 • Data warehousing concepts Certificate 2006

Contact this candidate