SUMMARY:

• Project Manager and Solution/Data Architecture Lead with required Capacity Planning for Big Data Project, Big Data ETL tools.
• Strong hands on experience with Big Data tools such as HBase, Hive, Sqoop, Pig, Flume and Apache Spark with SOLR/Scala/Python
• Strong hands on experience with Spark Streaming and Nifi for capturing real time using Kafka
• ELK (Elasticsearch, Logstash, Kibana) for Operational Monitoring.
• Designed and Developed Data Security for Big Data.
• More than 10 years experience as On Call Production support for various Production
• Systems to trouble shoot, provide downtime, error reporting and performance improvement.
• Over Twenty - five years of experience as Data Architect, Solution Architect, Business Intelligence Architect.
• Strong knowledge about developing Project Plans, Efforts, Estimation and Timeline of completion of the Project within Agile Work Environment.
• Extensive experience in Data Modeling techniques and maintaining Data Dictionaries using various Data Modeling tools such as ERWin and CA: Gen.
• Have a very strong background in Full Software Development Life cycle.
• Adept in leading effort to plan and implement a process which reduces Production Release efforts.
• Strong Business knowledge of State Medicaid System, Encounters 837 Claims, State Transportation System, State Government Child and Welfare System.
• Excellent interpersonal skills and very strong written and verbal communication skills.
• A team player with exceptional ability to mentor and train team members.
• Have received several recognitions and Spotlight of Excellence s from Project Managers and Senior Executives for s in various projects.

TECHNICAL SKILLS:

Database: Oracle 11g, SQL Server, HP-NonStop MP/MX, DB2, Access, Hive, HBase

Languages: C, Pro C, ETK (HP NonStop), J2EE / Java, Scala, Python

ETL Tools: Data Services by SAP, Microsoft DTS Packaging, SSIS, ODI, Ab Initio and Informatica

Business Intelligence: BOX II, Business Objects (BO) 6.5, SSAS

Scripting: C-Shell, Shell Scripting, OS/JCL and TACL

Platforms: HP-NonStop, IBM 3090, UNIX

Data Modeling: Cool: Gen, CA: Gen, ERWin, Power Designer 16.5

Version Software: TFS

NoSQL tools: Cassandra, Mongo DB and Neo4j

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Data/Solution Architect

Responsibilities:

• Drawing High Level Architectural plans for Big Data Implementation
• Design a detailed Big Data Solution for client based on Client requirements
• Support Code development activities with development team
• Work with Senior Partners to submit proposal to the client.
• Work on staffing plan for the Project implementation and timeline for the project completion
• Support the client for the designed Big Data solution.
• Lead and Developed Data Security process for Big Data solution.
• Lead and develop end to end Big Data solutions i.e. using Spark with Scala/Python for various financial institutions.
• Provide user experience client support for data available through Big Data tables.

Confidential, New York, New York

Project Manager

Responsibilities:

• Planning Data Architecture for Big Data using Hadoop(Hive) tables, review Data Models, work with Big Data DBAs to setup the partition strategy to achieve best performance.
• Work with Hortonworks(Hadoop vendor) to setup Hadoop environments in Development, User Acceptance and Production for various cluster nodes.
• Work with Informatica BDE ETL team to develop map reduce jobs from receiving source data to making Data available for Tableau using Greenplum database.
• Working with client Release Management to schedule release activities of different phases of the project.
• Work on transition plan for the client to implement completed systems in Production

Confidential, Monsanto, St. Louis, Missouri

Senior Data Architect

Responsibilities:

• Work with various Project teams to identify Data Requirements, develop Data Model and Data Dictionary. Data Models are built using Power Designer 16.5 using Oracle 11g Exadata, Setting up HBase table structure for HADOOP processing, Cassandra, Mongo DB and Neo4j. Work with the Oracle DBA to make Database changes based on project needs. Also involved with analyzing data and writing PL/SQL scripts for correct the missing data.
• Supporting Trait Staking Manager, Trait Quality Manager and Proficiency Testing applications within the Agile Work methodology.
• Member of Global Data Council for Monsanto to develop company wide Data Governance standards.

Confidential, Austin, TX

Release Manager, Data Architect and Project Manager

Responsibilities:

• Develop a Project plan, Efforts and Estimates for several on-going projects. Develop strategy for creating Data Models and building Data Dictionary. These projects are built on various platforms using SQL Server (SSIS, SSRS, and SSAS), Oracle 10g, HP Non-Stop NSK Blades system and SAP Business Objects XI for Data Mining and User based Query process. Have been participating in information-gathering sessions to determine and assess these projects requirements, identifying best suited architecture solutions in line with our enterprise data warehouse architectural standards.
• Worked as subject matter expert to implement Encounters 837 residing on Electronic Data Interchange (EDI) developed using J2EE to receive User Input files. These files were inserted into Oracle Database using ODI tool. As a subject matter expert I completed the code review to make sure that Input file data is mapped to the right data elements on the Tables.
• Working as a Release Manager to deploy all Data Warehouse Objects to Production. Medicaid Data Warehouse build objects include applying changes to Oracle, SQL Server (SSIS, SSRS, and SSAS), SAP Business Objects and HP Non-Stop Objects. Verify the deployed code matching the versioning software and finally deploy to production. Several scheduled reports for State Users are available thru Business Object BOX II for viewing once deployed to Production. Track all Production defects identified with a project, follow-up with Project teams, coordinate emergency deployment with various teams. Generate matrix for Executive managers weekly depending on Production deployment schedule.
• Working as Production On-Call Support Manager to manage Data Warehouse Production systems. All Production applications developed on HP Non-Stop, SQL Server and (SSIS, SSRS, SSAS) and Oracle 10g data are loaded during the regular weekend. As an On-Call manager, have been involved with trouble shooting in either of these environments. The newly refreshed data is readily available for users on Monday.
• Developed a Data Model using ERWin Data Modeler for the Claims Project. Developed a Project Plan, Efforts, Estimated size of the project and put a timeline for a team of five developers to build comprehensive SAP Business Objects BOX II ADHOC Reporting Solution. Strategized and developed ETL Solution to identify load strategies, data retrieval, maintains models for Business Objects AD-HOC Reporting as well as SQL Server SSRS reporting solutions. Developed Business Intelligence Solutions for Data Analysis.
• Developed a Data Model using ERWin Data Modeler for the Long Term Care Provider Hold Project. Developed a Project Plan, Efforts, Estimated size of the project and put a timeline for a team of six developers to build SSIS Packages on SQL Server to Stage the Providers who are put on hold by HHSC. Developed Business Intelligence using SSAS for Users to identify which Providers are put on hold and reasons for the hold. There were many weekly, monthly and quarterly reports developed using SSRS delivered to the customer.
• Made several changes to existing Data Model changes using ERWin Data Modeler to fine tune the Physical Database for performance reasons. Worked with the Project Team of eight developers to implement these database changes for HP NonStop, SQL Server Databases and Oracle Database System. The following changes affected Business Intelligence solutions using SQL Server and ODS OBIEE.
• Developed Data Model using ERWin Data Modeler for Medicaid Statistical Information System (MSIS) project which produced extracts needed to meet Federal requirements. Developed a Project Plan, Efforts, Estimated size of the project and put a timeline for three developers to develop application to extract and stage data on SQL Server using SSIS. Implemented Business Intelligence solutions using SSAS to support Federal Business requirements. Federally mandated reports were created using SSRS.
• Developed a Cash Voucher Data Model using ERWin Data Modeler for a massive conversion project. Developed a Project Plan, Efforts, Estimated size of the project and put a timeline for a team of 10 developers to convert Legacy transactions from were converted to a new platform on HP NonStop Blades server. Developed Business Intelligence solutions using SAP Business Objects for Cash Voucher to publish the data for HHSC based on their requirements.
• Worked as Technical Liaison between Transaction Processing team (HP NonStop NSK platform) and Data Warehousing (HP NonStop NSK, SQL Server, Oracle and Business Objects) team to identify ETL requirements for relevant data elements required by various State agencies. Several Business Intelligence solutions were introduced to present new data elements for AD-HOC querying and various reporting solutions.
• Developed Data Model using ERWin Data Modeler for Primary Care and Case Management. Managed a team of six to develop applications were built using ETL process on SQL Server using SSIS Package and HP NonStop NSK ETL developed in C++. Developed Business Intelligence solutions for Users to execute various types of graphs, Pie charts using the Business Objects reporting tool. Generated Business Objects reports for the users every month to find how many providers had been enrolled in PCCM.
• Designed and developed several Ad-Hoc reports in Business Objects for various data elements selection and presented them as a trend analysis report or Performance Metrics report especially for reports have to do with Hospitals.
• Mentored new team members on Medicaid throughout the design phase of Software Development life Cycle.

Confidential, Jefferson City, MO

Responsibilities:

• Worked as a Data Architect to capture accident report entered by highway patrol for accident analysis and reporting. The application was developed CA: Gen on Windows NT platform with C++ and Oracle 9i database.
• Worked as a Data Architect to design Billboard and Junkyard reports for State agencies. The application was developed CA: Gen on Windows NT platform with C++ and Oracle 9i database.
• Designed and implemented system which mails letters to Billboard and Junkyard companies about fees which are due. The application was developed CA: Gen on Windows NT platform with C++ and Oracle 9i database.

Confidential, Jefferson City

Responsibilities:

• Served as a Team Lead to report Support Order, collection and recovery of established Child support from the involved parents. The application was developed CA: Gen on IBM Platform.
• Worked as a Data Modeler and coder to establish the Child Support case with the State. Data Model was developed using CA: Gen.

Confidential

Responsibilities:

• Developed Statistical models for data sampling of Flight Test equipments to ensure quality control of the newly built Helicopter. Applications developed using C and presentation API.
• Developed a comprehensive graphical presentation system to present various metrics for the management to draw conclusions about the flight data. Applications developed using C and presentation API.
• Developed Ad-Hoc reporting utilities for the management. Applications developed using C and presentation API.