SUMMARY:

• 20+ years of experience in database design, architecture development, integration talents, Big Data, and AWS Cloud resulting in stable, scalable, and secure database - driven systems.
• 15 years of experience in Information modeling, data structures, master data management, data quality management, information governance, Big Data, data warehousing and Object/relational mapping
• 3+ years of experience in implementing Big Data solutions and AWS Cloud implementation/ migration using cloud deign principles.
• Successfully implemented teh Cloud solutions on AWS wif lift-and-shift and cloud native architecture for MIDAS
• Implemented data migration strategy to move 100+ TB file system from on-premises to AWS cloud environment using Direct connect and Snowball
• Demonstrated experience in Big Data platform using Hadoop ecosystems to implement teh Big data solutions in batch and real-time using Map-reduce/Tez, Spark, Hive & Hbase NoSQL database.
• AWS Solutions Architect, hands-on capability in building proof of concepts / Micro-service Architectures / Reusable Frameworks/ Continuous Integration Continuous Deployment
• Conduct feasibility, design thinking and cost studies and recommend cost-effective AWS Cloud solutions using different hive file formats to reduce I/O and costs and improve compute efficiency.
• Designed and delivered secure & high-availability Big-Data/Cloud solutions and implemented teh design principles to segregate storage and compute separately in AWS Cloud implementations
• Designed and delivered teh data warehousing solutions using AWS Redshift and Redshift Spectrum. Also designed teh custom framework to load teh data from S3 buckets & Hive tables into teh Redshift Cluster tables.
• Proficient at using Spark APIs to cleanse, explore, aggregate, transform, and store data interaction wif CSV, XML, JASON and Hive tables
• Implemented best practices to secure and manage teh data in AWS S3 buckets and used teh Spark custom framework to load teh data from AWS S3 to Redshift using teh field mapping config file.
• Built and manage EDW solutions using AWS Redshift and improve teh query performance using MPP design strategy and accessing data from S3 data lake using Redshift Spectrum external tables
• Successfully designed and delivered secure Cloud Solution using AWS services including IAM, S3, Redshift, Spectrum, Athena, EMR, EC2, VPC & RDS
• Demonstrated experience in Enterprise Data warehouse design using Star Schema, Extended Star Schema, and Snowflake schema dimensional models.
• Implemented teh Canonical Data Model (CDM) using teh XML schema to ingest teh semi-structured data into Hadoop Distributed File System (HDFS)
• Extensive experience in developing teh ER Conceptual/Logical/Physical data model for Big Data, transactional systems (OLTP) and data warehouse systems (OLAP).
• Years of experience in teh Information Technology industry including custom development as a Programmer, Systems Analyst, Solution Architect, Data Architect, Project Lead and Project Manager
• Managed full life cycle Custom Development (SDLC) for several business applications from inception to completion using Agile and Waterfall development methodologies.
• Highly adept at promptly and thoroughly mastering new technologies and adapting to existing corporate infrastructures, producing results immediately on hire in cross-functional IT roles.
• Exceptional interpersonal and customer relationship skills; serve as liaison between technical teams, business representatives, client management, and users.
• Years of experience in teh Information Technology industry including custom development as a Programmer, Systems Analyst, Solution Architect, Data Architect, Project Lead and Project Manager
• Managed full life cycle Custom Development (SDLC) for several business applications from inception to completion using Agile and Waterfall development methodologies.
• Highly adept at promptly and thoroughly mastering new technologies and adapting to existing corporate infrastructures, producing results immediately on hire in cross-functional IT roles.

TECHNICAL SKILLS

Big Data: CDH 5.5, HDFS, Hive, Pig, Hbase, Sqoop, OLH, Map-reduce, Spark, AWS Redshift

Cloud Technologies: AWS S3, EC2, Redshift, Spectrum, EMR, Cloud Formation, RDS, DynamoDB

Databases: Oracle 9i/10/11g/12c, Informix 11.x, SQL Server 2000/2005/2008 R2, Sybase 11.x

Data Modeling Tools: ERwin, S-Designer, Oracle Designer, ER/Studio

OS Platforms: Linux, AWS, UNIX (Solaris, HP-UX, AIX, SCO), Windows 2003/2008R2, OpenVMS

OLAP Tools: Cognos, Business Objects, Info View, WebI, and Oracle Discoverer, Crystal Reports

Dashboard tools: SAP BO Xcelsius 2008, SAP BO Dashboard Design BI 4.0

ETL Tools: Business Objects Data Services, MS SSIS, Pentaho

PROFESSIONAL EXPERIENCE

Confidential, Chantilly VA

Senior Big Data/AWS Solutions Architect

Responsibilities:

• Responsible for implementing teh Big Data Architecture solutions and developed teh HDFS/Hive database design using teh XML Schema and ingested teh XMLs/CSV data into HDFS
• Designed and developed teh NoSQL Hbase architecture to support for identifying teh version of teh changes made to teh Insurance Providers/Issuers Health Plan variables by teh CMS’s Oversight committee
• Successfully implemented Spark application using DataFrame to read from HDFS and analyze 200+ million Insurance Providers/Issuers Health Unified Rate Review (URR) records to measure teh rate increase and provide teh analytics to teh stakeholders.
• Analyze XML Schema to identify teh Parent/Child root element/XPath to enforce hierarchy and develop teh Logical data model to support teh cardinality and assign teh attributes from teh schema XSD files.
• Implement teh Enterprise Data Warehouse solution on AWS Redshift and architect teh table design to distribute and persist teh data in teh compute nodes to support query performance
• Implementing teh data transfer solutions using Apache Sqoop and Oracle Loader for Hadoop component to transfer data between Hive and Oracle schema tables.
• Written Hive query (HQL) scripts to implement teh data transformation logic (ELT) to support to teh data warehouse BI reports Cognos and Tableau.
• Implemented teh solutions to automate teh Data Dictionary and System Design Documentation using ErWin SDK wif ActiveX scripts.
• Participated in Technical Review Board (TRB) for approving teh technical solution to support customer needs. Conducted teh brown bag sessions in teh area of Information Architecture and Big Data Solutions.
• Work wif Government Technical Lead (GTL), organization leaderships to provide and execute Big Data Architecture strategies based on business needs.
• Responsible for providing thought leadership and guidance to teh team members in data architecture specific areas and health insurance domain efforts for teh development of teh applications QHP, URR, FFM.
• Designing and deploying dynamically scalable, highly available, fault tolerant, and reliable applications on AWS
• Define and deploy monitoring, metrics, and logging systems on AWS using Splunk and CloudWatch
• Expert-level noledge of Amazon EC2, Amazon S3, Amazon RedShift, Amazon EMR, Amazon RDS, Amazon ELB, Amazon Cloud Formation, and other services of teh AWS family
• Implemented best practices to secure and manage teh data in AWS S3 buckets and used teh Spark custom framework to load teh data from AWS S3 to Redshift using teh field mapping config file.

Confidential, Washington DC

Senior Data Warehouse Architect

Responsibilities:

• Designed Enterprise Data warehouse (EDW) for all 204 bankruptcy, district and appellate courts and collecting teh transactional data from Case Management/Electronic Case Files (CM/ECF) system.
• Designed and developed Data Marts for CGI’s Momentum /Judiciary Integrated Financial Management System (JIFMS) application.
• Responsible for designing teh Conceptual, Logical & Dimensional modeling and get approved from teh business domain experts.
• Responsible for creating and maintaining teh metadata repository to include teh source data elements, definition of an entity & attributes, ETL mapping documents, perform gap analysis, data profiling statistics
• Participated in Data Governance (DG) council and define set of procedure and policies and implemented through Master Data Management (MDM) process.
• Using IBM System architect to provide teh integrated solutions wif business processes, application, data stores & server architecture wif TOGAF enterprise architecture.
• Develop and execute strategies for migration of customer data to appliances, integration wif ETL and BI processes and environments
• Evaluate new Business Intelligence technologies, features, and products. Lead and participate in Proof-of-Concept projects and prototyping
• Provided teh bi-directional, peer-to-peer data replication solutions using IBM Infosphere Data Replication to support near real-time BI analytics.
• Implemented teh BODS Real-Time ETL process using IBM InfoSphere Data Replication to support EDW.
• Data Profiling and Data Modeling for teh Case Management/Electronic Case Files (CM/ECF) system.
• IBM InfoSphere CDC installation and administration for teh Real time process on BODS/Oracle/Informix servers.
• Configure and maintain XML Schema, Message subscriptions and Message XML destinations for teh CDC
• Configuring and administrating teh Apache MQ server for teh Real time XML queues and Administrating teh BODS Real time Services and Adapter Instances
• Develop and Implement teh ETL technical architecture, data acquisition techniques and decision rules
• Implements teh Entity & Attribute standards and work wif DBA to implement teh strategy for teh SQL query performance tuning.
• Work wif BO Architect to implement teh row level security to access multiple court records to support teh EDW architecture for every subject area
• Establish and enforce technical standards and Define meta data standards for teh data warehouse
• Develop Best Practices documents for data dictionary, MDM, ETL mapping documentation

Confidential, New York, NY

Data Warehouse / BI Architect (Business Objects)

Responsibilities:

• Administrator for Business Objects (BO) and Crystal Enterprise servers managing over BO Servers in multiple locations supporting several hundred users.
• Experience in Business Objects Enterprise XI R2/3.1/ BI 4.0 installation and security, User and server administration and maintenance
• As a Data Architect, responsible for designing teh ER logical model & Dimensional modeling and get approved from teh business domain experts.
• Developed teh data warehouse dimensional model for SAP Financial data mart to support teh analytical and BI reports.
• Developed several ETL SSIS packages and scheduled to extract teh data from teh SAP FICO module and loading teh data to teh SAP Financial data mart.
• Design and developed teh ER logical and physical data model for teh Qatar Scholar Management System and Enterprise Scholars & Student applications
• Designed and developed teh Universes for different functional application modules and resolved teh Loops, Chasm traps & Fan traps using alias and contexts.
• Query performance improvement in teh Universe design using teh Keys, filters & compatible objects
• Experience in developing teh operational and analytical DeskI/WebI reports using different data providers
• Experience in creating teh Crystal reports (all versions) for teh operational and analytical reports.
• Managed full life cycle custom report development for several business applications from user requirement to signoff to teh production environment.
• Designed and developed teh Enterprise Dashboard using Xcelsius to provide teh performance monitoring and performance management wif KPI to teh executive management.
• Developed teh custom web services and used Business Objects QAAWS to create teh Xcelsius Dashboard
• Experience wif Business Objects Data Integrator, Application Foundation Dash board and VBA.
• Reengineered security and management tasks to suit clustering environment.
• Server migration experience from XI R2 to XR3.1 and BI 4.0 configurations
• Experience in MS SQL Server administration wif HA architecture and DR setup wif log shipping.
• Recommended improvements to existing applications to meet performance and scalability requirements.
• Communicate wif all teh application users in solving all teh issues related to teh application.
• Improved space management and monitoring to meet expansion needs and streamline teh effort required.
• Analyzed query patterns of 3rd party application and recommended improvements.
• Prepared teh different type of drill down analysis reports to provide teh detailed visibility about teh Students and Scholars programs and financial responsibility.
• Design and developed teh various analytical reports for state and federal education departments.