SUMMARY

• Experience in years - Total (23); BI Architect (8); Mainframes (15)
• The TOGAF philosophies modularization and standardization were used across the experience
• More TEMPthan 23 years of total experience in the IT industry with diversified noledge, as Data Analyst/Business Intelligence Architect (specialist in QlikView and Excel developments; intermediate in Tableau, Cognos, BO Web Intelligence), database administration and ETL
• Mainframe development experience of 15 years, working with various IBM tools and technologies. IBM Vendors like CA, Compuware, EMC
• Tremendous experience in QlikView development (dashboards, scorecards, reports, KPI’s), good understanding ofQlikView architecture with SQL Server
• As Tableau enthusiast, completed many PoCs to migrate from QlikView to Tableau
• POC’s in migrating QlikView components to Cognos 11
• Extensive experience with the design/development/scripting of QlikView applications
• Been involved in all data mining phases - business understanding, data understanding, data preparation, modeling, evaluation and deployment
• Comprehensive understanding of data analytics techniques - Visualization, Correlation, Regression, Forecasting, Classification and Clustering
• Good experience with Microsoft Excel techniques including creating PivotTable, Pivot Chart, and VBA Scripting
• Sharp eye for detail and strong understanding of user-centered design principals
• IBM certified DB2 9 Database Administrator
• Expertise in Dimensional Data Modeling (star-like schema and snow-flake schema), identifying Dimension & Fact tables, denormalizing the data, data cleansing using Scripts, slice & dice using Visualizing Objects

TECHNICAL SKILLS

Reporting/ GUI Tools, Visualization: QlikView 12.x, Qlik Management Console (QMC), Business Objects, Tableau 10 (intermediate), Cognos 11

Database Management Systems & Tools: DB2, MS SQL Server, OLE/DB, ODBC, SSIS, Oracle

Microsoft Tools: MS Outlook, MS Office (Word, Excel, PowerPoint), MS SQL Server SSIS, SSRS, SSMS

Languages: SQL, T-SQL, PL/SQL, HTML, JavaScript, VB Script, UNIX, Linux, Shell Script

Mainframe: COBOL, PL/me, JCL, SAS, Easytrieve, IBM Net.Data, CICS, IMS-DC, ISPF Panels, IMS-DB, IDMS, DB2, VSAM, REXX, ISPF Skeletons, ISPF Tables, Edit Macros, CA7, CA-VIEW, PRO-J, XPEDITOR MVS/CICS, FILEAID MVS, PACBASE, JobTrack, SDF2, MQ-Series, Abend Aid MVS/CICS, FILEAID/DB2, OMEGAMON for CICS, APPTUNE for DB2, CATALOG MANAGER for DB2, DFSORT, SyncSORT, ICETOOL, StarTool, QMF, QMF Procedures, SPUFI, DB2 Utilities, CA-UnicenterData Warehouse Tools Fact and Dimensions Tables, QVD, TDE

Web: HTML, XSL, XML, XSLT, Perl, CGI, Java Script, CSS

Big Data: (Basics) Hadoop concepts, NoSQL, MapR, Couldera

Machine Learning: (Basics) Anaconda, Python, Jupyter Notebook

OthersService: Now, Jira, Citi OPPM, Citi Planview, InfoMan, FieldGlass

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Business Intelligence Architect

Responsibilities:

• Transform legacy BI assets from Excel, PPT, BO to Strategic BI Assets in QlikView
• Completed Tableau PoC’s to migrate QlikView to Tableau; including advanced concepts like LOD
• PoC’s to migrate to Cognos 11
• Responsible for BI Architecture, data extraction architecture, data modeling, and data cleansing
• Created QVDs for optimized loads and better maintenance
• Creating data models to handle complex relationship between multiple fact tables
• QMC Jobs Scheduling and Monitoring. Moving the files between DEV, UAT and PROD
• Creating Tasks in QMC for AP (Access Point) deployment
• Worked with business users to understand and develop the important key KPI’s from functional areas - finance, operations, products, clients, data center, etc.
• Designed and developed extensive QlikView Reports & Dashboards using combination of charts and tables
• Develop Set Analysis, User Defined Function, and Subroutines to provide the custom functionality in QlikView Applications
• Implemented incremental load logic and Binary Load for better performance of QlikView loads
• Complete performance tuning by analyzing and comparing the turnaround times between SQL and QlikView
• Created different types of reports such as master/detail and cross tab for trend analysis
• Key development includes Rapid Risk Scorecard, Infra Agent Deployment Dashboard, Linux/Wintel Inventory Reports
• Perform Digital Analytics using QlikView objects like List Box, Slider, Buttons, Charts, Bookmarks, Alternate States, Charts like Pie, Bar, Line, Waterfall, Pareto etc.
• Developed User interactive Sheets and Reports as business needs
• Create predictions and forecasting for finance and Operational teams

Confidential

Project Manager

Responsibilities:

• Wrote interface programs thru IBM REXX to generate reports from InfoMan and ServiceNow
• Migrated all reports from InfoMan to ServiceNow
• Executive dashboards and reports generated using these sources thru QlikView
• Provided analytical support for the efficient operation of global consumer markets
• Responsible for the creation, direction, and delivery of operational status reports
• Led initiative on refining the departmental reporting for Change Management within ServiceNow
• Collaborate with various departmental leaders for reporting requirements and delivery
• Trained offshore team members for the regular maintenance of deliverables
• Initiated a Project in OPPM, based on requirements from various communities
• Tracked, monitored workforce and artifacts, processed and closed the project in Planview

Confidential

IBM DB2 DBA / Mainframe Developer / Project Manager

Responsibilities:

• Supported the entire application upgrade with respect to DB2; creating, modifying and dropping the DB2 objects based on requirement
• Prepared explain reports to better utilize the indexes using CA-Unicenter
• Designed the architectural design and determined the necessary space for creating a new database
• Performed database maintenance activities like running useful DB2 utilities against the database objects
• Participated in all the DB2 meetings for discussion of status updates
• Created audit reports of the DBAs having DBADMIN and SYSADMIN access
• Oversaw database housekeeping activities encompassed, running DB2 Utilities, taking backups and Job monitoring.
• Creating stored procedures for Multi-DB2 tasking
• Responsible for coordination with other dependent Application teams like Interfaces and distributed