OBJECTIVE:

To be on the frontline of the dynamic highly motivated team in charge of delivering actionable data insights utilizing best practices in data management, data quality, data governance and data harmonization. I am eager to roll up my sleeves to design and deliver next data pipeline capable of igniting powerful data visualizations, business insights and/or analytical forecasting.

SUMMARY:

• Over the span of my career, I have successfully worn many ‘data’ hats to deliver timely results that met and exceeded high management and client expectations, all while self - learning multiple technologies, productively collaborating with my peers as well as coaching less experienced talent.
• I excelled at broad range of job functions in the data integration space: process re/design and innovation, improvement and automation, coding, development, technical leadership, liaison and relationship building with internal and external technical teams, requirements gathering, data modeling, peer code review, data quality, regression testing, IAT/UAT coordination, offshore coordination, release management, debugging, production support.
• I am highly motivated to dive into unfamiliar data domains and processes, building on my experiences across spectrum of disciplines and industries: Benefit Management, Payroll and HRIS Outsourcing, Compensation and Talent Management, Operational Effectiveness, Operational Finance and Accounting, Retail Couponing, Marketing, Credit Card Authorization, Fraud, Settlement, Sales and Revenue, Government Compliance
• Proven record of effectively managing BI/ETL offshore resources located across the globe
• Design, implement, build and maintain OLTP and Dimensional Data Models
• I have a proven record of hands-on design & development experience across a broad range of products, technologies and methodologies. Hands-on experience with analysis, design and development for file/database/reporting and operational system conversions, outsourcing and data quality initiatives
• Additionally, took initiatives on design and implementation of supplementary processes such as DDL management, compliance and security administration. Designed and implemented automations for row and object level security for reporting databases, reporting tools and multi-tenant reporting portal
• I am accountable for results, aspire to role up my sleeves and get things done, thoughtful problem solver and outside of the box thinker, eager to learn and always looking for the opportunities to share, collaborate and build out relationships
• I pride myself on meeting deadlines while implementing reliable, scalable, highly resistant, automated solutions. I strive in dynamic, work-life balanced, collaborative, fast-paced environments led by strong visionaries characterized by high personal integrity. I admire leaders who are empowering with their vision, pragmatic in their strategy, reiterate lessons learned, held their teams to high ethics and accountability standards, hire the brightest minds, inspire professional growth and excel at building consensus across the department lines.

TECHNICAL SKILLS:

• Data and Process Modeling: SAP PowerModeler, Erwin, Visio, MS Power Point and Excel
• File/Script/ETL Processing
• Unix
• Pentaho
• SAS Base/Macro
• Informatica
• Perl, PeopleSoft SQR, Python
• Databases: Postgres
• SQL Server
• Teradata SQL
• Oracle
• DB2/UNIX
• DB2/MVS
• Informix
• BI Tools: Cognos 10/ReportNet/Cognos MDX
• Cognos AccessManager/IWR/OLAP
• Tableau(2013), Microstrategy
• VBA
• Scheduling Tools: Jenkins
• Control-M
• Unix Cron
• Source Code Management: GitHub, MS Source Safe

PROFESSIONAL EXPERIENCE:

Information Architect

Confidential, Chicago, IL

Tools: /Technologies: Postgres SQL, Jenkins Scheduling Automation, Pentaho ETL, Microstrategy BI

• Design and implement near-real time Data Lake from variety of data sources with mix of API, traditional batch jobs and near-real time scalable data pipelines and data quality automations
• Reduce refresh time of pre-existing reporting database solution by utilizing outside the box thinking and problem solving and by building out collaboration across the department lines
• Design Marketing Insights Data Mart, prepare and cleanse data for Brand/SEO/Lead/Affiliate Management dashboards
• Build out Finance and Accounting Focused Operational Data Store and Data Marts
• Proposed creation of Data Pipeline Logging DB to capture runtime statistics for audit and operational alerting
• Optimize and modernize analytics data prep pipeline to reduce data load times and improve data quality

DW Data Sourcing Analyst

Confidential, Chicago, IL

• Member of the team, responsible for converting Financial PeopleSoft system to SAP
• Analyze pre-existing PeopleSoft reporting inventory, document data lineage and create data dictionary
• Perform GAP analysis between existing reporting inventory vs SAP out-of-the box reporting deliverables
• Present gap findings to operational and executive management during technical and business design meetings
• Significantly improve quality of deliverables after volunteering to oversee offshore development

Tools: /Technologies: SQL Server/SSIS, PeopleSoft Finance/HRMS Code, SAP BW/ECC

Information Architect

Confidential, Hoffman Estates, IL

Tools: /Technologies: SAP Power Designer, Teradata/SQL, Microstrategy, Tableau

• Member of the Agile team responsible for the design and implementation of Targeted Campaign data mart - a reporting solution with actionable insights measuring effectiveness of Unica inbound and outbound campaigns
• Collected and analyzed requirements, design of dimensional data models and orchestrate data pipelines
• Closely collaborated with statisticians and business analysts
• Analyzed and optimized SQL, enhanced data models to achieve optimal user experience
• Cleansed and transformed data from the variety of the internal data sources to assist statisticians with data studies and comparative analysis

Information Architect

Confidential, Network, IL

Tools: /Technologies: Teradata, ETL/SQL, Cognos, Excel VBA, Unix Shell Scripting, Oracle, SAS

• 50% coding and managing off shore team members
• 50% liaison between business and business technology teams - manage data sourcing workflows, translate business requirements into technical requirements, design data models, lead Agile UAT and Design sessions for new data implementations, assist end business users with report and data validations
• Develop variety of data transformation and reporting processes:
• Monthly/Weekly Fraud, Risk, Sales, Pricing, Revenue, Brand and Product Management reporting
• Address cleansing and matching for ATM proximity analysis
• Fraud Identification data cleansing and matching
• Designed and coded merchant sales recursive hierarchy conversion out extract to 3rdparty (complex business rules)
• Self-learned basics of Perl to process and split files
• Self-learned basics of Cognos MDX and Visual Basic to create monthly automated reporting solutions combining data tables and visualizations

Confidential, Lincolnshire, IL

HR/Payroll Outsourcing DW Information Architect

Technology: Erwin, Visio, DB2/Unix, DB2/MVS, Oracle, Oracle FDW from DB2, Informatica, Cognos

• 50% coding, designing data models, production support
• 50% managing data sourcing workflows, process improvements, release management, establishing development priorities, handling changing client priorities, assigning work to off shore team members, peer code and test plan review

Data Modeler and Technical Analyst

• Complex data analysis across HRMS functional areas
• Collaborate with internal People Soft implementation teams to understand data lineage
• Design and enhance HRO DW data model as result of data lineage gap analysis
• Design client specific reporting data models for Compensation, Talent and HR Operations Management
• ETL/BI reports/cubes analysis, design and development, ex Payroll Cubes (from conception thru automation)
• ETL/Cognos issue debugging and performance tuning
• Design and develop flattening of complex recursive hierarchies for row, object and reporting portal security
• Coordinate maintenance and system enhancements with IS departments and 3rd parties
• Responsible for innovation, data quality, process improvements and automation of payroll file conversions
• Oversaw ongoing support coordination and issue resolution by offshore team
• Coached less experienced associates on Client data models and PS Query Setup, Appfluent
• Performed security audit of Cognos Access Manager and Cognos Portal
• Coordinated Security and Cognos team effort to prevent SQL injection threats against Cognos portal
• Designed and implemented process to perform fuzzy name and address matching across multiple MVS systems and MVS/DB2 databases (self-learned SAS/Macro for purpose of implementation)

Programmer Analyst

Technology: SAS, JCL, QMF, File-Aid, SyncSort, Object Oriented Cobol

• Analyzed and converted HR/Payroll/Benefits data from 3rd parties system
• Developed, enhanced and maintained file conversion routines for batch data processing
• Responsible for government compliance reporting
• Coached less experienced associates and co-led internal technical training, prepared exercises for internal debugging class, initiated and maintained reference documentation

Programmer

Confidential, Oak Brook, IL

Technology: Natural/Adabase/MVS/AS400, MS Access and Excel, Rumba Client Access

• Coded programs using Natural language to update customer data in ADABAS/VSAM database
• Verified, reformatted, cleansed and loaded EPA State data utilzing MS Access, Excel and JCL
• Uploaded prospective leads from 3rdparty files into AS400-based telemarketing database

Tutor

Confidential, DeKalb, IL

Responsibilities:

• Assisted students with development of problem solving skills in mathematics, statistics, and econometrics

Research Aid

Confidential, DeKalb, IL

• Analyzed Chicagoland precipitation data using Quattro Pro for Windows NT and Unix/Solaris
• Assisted in compiling research results for publication