SUMMARY:

• Motivated professional with more than 20+ year of experience in IT as Business Intelligence Architect, Solution Architect, Big Data Hadoop solution Architect, Technical Project Lead expertise on Data Warehouse(DW), Data Marts, ETL process, OLAP design and solution Development using the Software Development Life cycle. Also expertise in Mainframe legacy application Design and Development using Retail industry and Government agencies.
• 2+ year of Big Data Solution Architect experience in designing conceptual, logical and Physical design for structure and unstructured data feed into Hadoop and using the data for analytical reporting.
• 7+ years of experience in Data Warehouse Dimension Modelling, Database design, ETL, Business Intelligence report, KPI and Dashboards.
• Experience in building the Data Warehouse application using Kimball and Inmon approach based on the EDW landscape.
• Experience in BI Architect in designing Conceptual, Logical and Physical design using different Normal form and Schema like Star Schema, Dimension, Slowly changing, Snowflake, Conformed Dimensions, facts like Metrics and KPI using ERWIN.
• Experience involves defining different layers like landing/staging, ODS, ADL, aggregator layer and DataMart, recovery point layers, ETL schedule and flow, mapping Design and workflow design using IBM Datastage, Cognos and Netezza.
• Experience as Solution Architect designing and delivering solution deployment architecture, infrastructure sizing, performance tuning and scalability options for test, development and production environment.
• Involved in full scale Projects from inception to deployment in IBM Mainframe environment, like Creating new Online user facing screens in CICS, writing Cobol programs, creating JCL for batch jobs, building SQL queries to read data from DB2 Table in SPUFI as well as program.
• Experience with SDLC, Project planning, managing Team and and mentoring new people.

TECHNICAL SKILLS:

Database: UDB/DB2, Oracle 10g, Netezza, Microsoft SQL Server, NoSQL, MongoDB, MS - AccessCouchbase, CouchDB, SAP HANA, IMS DB/DC, IBM DB2

Data Management: Master Data Management, Data Federation, Data Governance, DataTransformation (ETL), Data Integration, ODS, OLAP, EDW, Data Mart, Meta Data.

Data Modeling: ERWIN

Data Schema: Star Schema, Snowflake

BI Tools: IBM COGNOS, SAP BI/BO

ERP: Oracle e-business Suite, SAP ERP 6.0

SDLC Methods: Agile, Waterfall, RUP

Data Warehouse: IBM Infosphere DataStage, Informatica, SAP BODI, Pentaho

Reporting: IBM Cognos, Crystal Report, Dashboard, Qlikview, Tableau

Big Data Technologies: Hadoop eco system include PIG, Hive, Yarn, Sqoop, Hbase, Impela, Storm, Fume, Cloudera CDH 5.0.

Mainframe Language/Tools: COBOL, CICS, DB2, FILE-AID, QMF, TSO, ISPF, SPUFI, JCL,Changeman, Panvalet.

Other Tools: IBM Enterprise Service Bus(ESB), TOAD, MKS Source Integrity, MS Project, MS Office, MS Sharepoint, IBM MQ Message Broker, FTS, SSIS, JAVA, J2EE

Operating System: Windows, Unix/Linux, OS/390, AS/400.

Hardware: IBM-3090 mainframe, UNIX/Linux, Window

PROFESSIONAL EXPERIENCE:

Confidential, MA

Senior Programmer analyst/Solution Developer

Responsibilities:

• Involved in Big data Solution to design a system to read unstructured data from Company sale Web site and Structure OLTP data from Store sales to HDFS file system using the technologies like Fume, Sqoop, Pig, HIVE, HBASE, No SQL, Strom, Zookeeper, Oozie and create different analytical report for the marketing and sales department.
• As part of the new Company EDW roadmap to manage the global data, worked in moving the Master Data Management (MDM) system from Legacy system to Oracle Platform. Worked in create Physical design documents, detail design document and data mapping documents, Models, Key Decision Document.
• Created and Maintain Conceptual data model, logical data model and physical data model in ERWIN. Design dimension data model and involve in create Star /Snowflake Schema Fact and Dimension table models.
• Worked with Business, SME and End user to identify the requirement and worked on mapping the data source, ETL needed to create Data Mart for Analytic and reporting.
• Involving in generating DDL’s using ERWIN to create Database objects.
• Created the ETL jobs streams in IBM DataStage to load Data into ODS, ADL (Atomic Data Layer), Aggregation layer and DataMart in IBM Netezza environment keeping Security, User access, and securing Key financial data as per Sarbanes-Oxley and Company guideline.
• Involve in performance tuning of sources, targets, mappings and transformation to optimize session performance.
• Involve in Configure, Monitoring and Managing batch jobs in ESP Job scheduler.
• Involved in Create Reports for Users using Cognos, Qlikview.
• Involved in complete Deployment cycle from Dev to QA to UAT to Production.
• Involved in Complete Design, Build, Testing, integration and deployment of IBM Mainframe applications using COBOL, CICS, DB2, IMS DB/DC, JCL. VSAM, SPUFI, File-Aid.

Environment: Mainframe Stack: IBM OS/390, MVS, COBOL,DB2, IMS DB/DC, XPEDITOR, File-Aid, JCL, VSAMDW Stack: Erwin, Oracle, Congos, Netezza, DataStage, DB2, SQL Server, CrystalReport, Qlikview, SSISBig Data Stack: Hadoop eco system include PIG, Hive, Yarn, Sqoop, Hbase, ImpelaStorm, Fume, Tableau.

Confidential, Florida

Senior Programmer Analyst

Responsibilities:

• Involved in analysis, online screen design and coding of Paternity Affidavit and Support Order online programs according to the new UIFSA forms using TELON, IMS DB/DC, COBOL II, Endeavor.
• Involved in compilation and unit testing of Client approved Unit Test Plan using Expeditor, Endeavor.
• Involved in creating test cases, testing and documenting the before and after database changes snapshot, online screen printouts with test conditions for the output result.
• Involved in Integrated unit testing of the Paternity Affidavit and Support order system in user test region.

Environment: IBM OS/390, MVS, COBOL, TELON, IMS DB/DC, XPEDITOR, Endeavor, File Aid for IMS, JCL, VSAM, and TSO/ISPF.

Confidential

Responsibilities:

• Involved in CRIS-E Application Entry sub system support group for analysis, development, enhancement and testing of CRIS-E modules using TELON, IMS DB/DC, COBOL as per the client request which comes from different county, development group, analysis and Design group. Fixing of the problems is different test phases.
• Extensive testing of Online/Batch programs using BTS, Expeditor, Telon TestFacility.
• Writing of Unit Test plan and creating unit test data and promoting the program to System test region for system test using SCLM utility.

Environment: IBM 3090, MVS, COBOL, TELON, IMS DB/DC, SCLM, XPEDITOR, BTS, Telon test facility, FILE-AID, SDF,JCL, VSAM, TSO/ISPF.

Confidential, Dallas

Responsibilities:

• Involved in Design, coding and testing of HTML forms, servlets, and dynamic HTML codes to display the results using JAVA, Javascript, Servlets, HTML.
• Also involved in writing code to extract data from Oracle database based on the query entered on the screen.

Environment: JAVA, JDBC, Servlets, Javascripts, HTML, Win-95/NT, Oracle 7.3.xNetscape Enterprise Server.

Confidential, Texas

Responsibilities:

• Involved in the Analysis, development and testing of online entry screens and Batch report modules for VMF system using COBOL II, CICS, SDF, DB2.
• Also involved in Analysis, Conversion and testing of Vendor Master File system programs from OS/VS COBOL to COBOL-II and enhancement of COBOL II features in the program.
• Tested the online programs. Also tested for Y2k compliant.

Environment: IBM 3090,OS/390, MVS, OS/VS COBOL, COBOL-II, CICS, DB2, TELON,IMS IMS DB/DC,QMF,PLATINUM, PANVLET, JCL, VSAM, TSO/ISPF.

Confidential, New York

Responsibilities:

• Involved in the preliminary manual study and analysis, modification of data fields which are affected by year 2000, and other fields like Policy Number, Amount fields to adhere the future requirement of Insurance System and there related fields as per the clients specs of the programs and writing specs for the date fields which are effected by year 2000.
• Implemented the windowing technique for the date field expansion.
• Tested all the programs for Y2K compliant using the test and production data. Also involved in QA test the changes to adhere to the shop standards.
• Also involved on and off with the Conversion group for the conversion of old programs from OS/VS COBOL to COBOL-II.

Environment: IBM 3090, MVS, COBOL-II, CICS, DB2, IMS DB/DC, PL/1, JCL, FILE-AIDTSO/ISPF, SPUFI.