SUMMARY:

• Data Analyst with 7 years of experience specialized in Data analysis, Metadata management, Business Analysis, Data governance, Big data Development, Enterprise Data Management, Data Preparation life cycle, IBM DB2 administration for Z/OS including Designing, performance monitoring, maintenance, query analysis, optimization, backup and recovery and migration of database.
• Good knowledge on Machine Learning Algorithms, Data warehouse concepts and Data visualization.
• Proven achievements in effectively collaborating with various technology teams within fast - paced, agile environments.
• Consulted with business partners and made recommendations to improve the effectiveness using Big Data systems. Integrated new tools and developed technology frameworks/prototypes to accelerate the data integration process. Have theoretical knowledge of machine learning algorithms.
• Experience designing, reviewing, implementing and optimizing data transformation processes in the Hadoop. Able to consolidate, validate and cleanse data from a vast range of sources - from applications and databases to files.
• Capable of extracting data from an existing databases & Files. Experience in solving issues during data extraction and data movement across systems.
• Developed and automated several processes by creating reports with sound knowledge on business process and reporting skills and improved speed to market of applications.

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, CT

Data Analyst/EDM Solutions Lead

Environment: SQL, Podium Data, Collibra, Data Lake, HDFS, Hue, Hive, Impala, Pig, Python and Looker.

Responsibilities:

• Discovered, Prepared and analyzed claims data and created an automated process for Cancer Analytics.
• Designed and implemented an automated process for executing Data quality checks and data certification in Datalake.
• Designed and implemented a robust framework for Metadata repository for entire organization which acts as a single source of truth for Metadata. It saved more than 2M USD because of automation.
• Ingested data from variety of data sources like Teradata, DB2, Oracle, SQL server and Postgres SQL sources to data lake using podium and solved various data transformation and interpretation issues during the process.
• Created various communities and domains for Business glossary, Information Governance Catalog in Collibra and moved data to Data lake using Collibra connect.
• Responsible for data governance processes and policies solutions using Data Preparation tools and technologies like Podium and Hadoop.
• Created an input agnostic framework for data stewards to handle their ever-emerging work group datasets and created a business glossary by consolidating them.
• Recommended various technical improvements to teams unfamiliar with big data.
• Created Domains for industry standard code sets and proprietary code sets and maintained reference data by setting up approval workflows.

Data Analyst

Confidential

Environment: IBM Information Analyzer, Teradata Studio.

Responsibilities:

• Used IBM Information Analyzer to perform column analysis and see profiling results.
• Classified 5000+ elements using my Health care knowledge and Business Glossary
• Written various complex SQLs in Teradata to analyze and understand quality of Data.
• Collaborated with SMEs for reviewing the classification and worked with IT team for encryption.

Mainframe Developer

Confidential

Environment: DB2 V10 for z/OS, COBOL, Endeavor.

Responsibilities:

• Gathered and reported on reconciliation requirements from Business.
• Identified key fields necessary for reconciliation.
• Written Cobol DB2 programs to create reconciliation reports between Finance and Individual data marts.

Data Stage Development Lead

Confidential

Environment: DB2 V10 for z/OS, Data Stage v9, Teradata v14, File aid, ESP, Jenkins, JCL COBOL.

Responsibilities:

• Executed requirement specification, analysis, mapping and business analysis.
• Translated customer requirements into formal requirements and design documents.
• Delivered ETL design solution to the customer in line with all time and quality specifications.
• Lead the offshore development team and successfully delivered the project.

Mainframe Performance Expert

Confidential

Systems Used: DB2 V10 for z/OS, Strobe, IBM Database Manager, File-Aid, Endevor, ESP, SM, MXG, Easytrieve, COBOL, & REXX

Responsibilities:

• Successfully saved over 2,000 Peak Hour MIPS which resulted in over a $1M dollar savings in terms of Mainframe Operational cost.
• Initiated assessments of the top Confidential consuming batch jobs or online transactions based on the mainframe Confidential consumption report and correlate the findings to the cost associated with each job/transaction.
• Conducted high-quality performance analysis and profiling on SQL application code, and then made strong recommendations on performance tuning options, benchmarking these recommendations using DB2 Explain, and/or IBM Optimization Service Center.
• Routinely analyze data trends, COBOL programs, and various utility JCLS, and make suggestions based on findings.
• Consistently recommended processes and technical solutions to various teams and departments on BigData questions and issues, becoming a Lead on BigData initiatives.
• Strategically utilize the latest features of DB2 like Multi-row fetch/insert, PAGEFIX, of buffer pols, CICS Thread safe, creation/usage of optimal indexes as appropriate and then supported application teams in the implementation of SQL Query/code changes.
• Monitored and performed SQL Query tuning, database parameter tuning, subsystem level tuning (including buffer pool coupling facility), memory tuning using TMON, Omegamon & Platinum.

Confidential, NJ

DB2 Database Administrator

Responsibilities:

• DBA & technical lead in an environment of 18+ DB2 production subsystems, managing projects ranging from database migration from DB2 V8 to V9; V9 to V10 to database design and support.
• Developed and maintained REXX & JCL tool scripts which can be refined / reused across application portfolios to identify / remediate incompatibilities associated with each DB2 version migration.
• Successfully ensured that all projects and upgrades were completed efficiently, accurately, and expediently, while avoiding a $1M dollar penalty to the organization.
• Converted more than 30,000 DBRMs to Packages, 20,000+ Simple Table Spaces converted to Universal Tablespaces (UTS), Explain Tablespaces migrated to V9 and then V10 format, 50,000 Packages associated to over 10,000 plans were converted from private to DRDA protocol.
• Provided top-notch technical support to clients, team members, subordinates, other departments, and Executive Management.
• Routinely analyzed Confidential hogging SQL queries using Data Studio and made performance-tuning recommendations as necessary.
• Planned all significant performance monitoring using Omegamon reports and traces to capture storage usage, buffer pool usage and analysis, and EDM pool usage and data on deadlocks, lock escalations, and more.
• Accurately managed all database accesses, addressed user granting/revoking needs, and DBADM Authorizations, as well as user creation and object level permissions using Platinum Products (RC/Secure).
• Created a buffer pool data analyzer tool that scans the buffer pools and provides detailed information about improvements.