SUMMARY

• Strong technical experience in IT with Business Intelligence solutions, Database Administration, Metadata Management, Big Data, Systems Analysis, Data Discovery, Data warehousing, Big data Management, Data Governance, Reporting, Data Integration, ETL, Data modeling, Design, Development, Implementation and Testing of Data Pipelines, Database/Data Warehouse/Data Marts/Client/Server/Legacy applications for Government, Insurance, Banking, CRM, ERP and Telecommunications domains.
• Experience in implementing domain driven Data Architecture, Data Modeling Database Administration, Business Data Analysis and Enterprise Metadata Management(MDM).
• Experience in understanding the business needs, analyzing and providing the best technical solutions using Business Intelligence and COTS/GOTS tools listed and not limited to SAP Business Objects, SAP Business Objects Data Services, QlikView, Qlik Sense, Data Integrator, Xcelsius, Tableau, Web Intelligence, Oracle Warehouse Builder - OWB, OBIEE 11g/12c, BI Answers, BI Publisher, BI Dashboards, ETL, Data integration using Business Objects Data Services/Data Integrator, Talend, Informatica, Pentaho and DataStage across disparate platforms including Relational Databases like Oracle (Unix/Linux), MS SQL Server (Windows), Amazon Aurora, AWS RDS, EC2, S3, Redshift, Qlick Sight, Athena, IAM, Lambda, API Gateway, SAP R3, DB2 (Mainframe), Lambda, Sybase, Postgres, DynamoDB, My Sql and other non-standard data sources in processing large volumes of data in hundreds of terabytes.
• Extensive experience in collaborating with team members to develop data plans and proposed solutions that will interface and enhance current Government-sponsored program architectures while conducting data design reviews and data integration in support of project transition into production. Expertise in software development life cycle, System Analysis, Design, Development, coherent with Data Cleansing, Data Quality, Data Ingestion, Data Conversion, Data Collection, Data Discovery, defining Datasets, Performance Tuning, Testing, Deployment and Support ensuring data management steps, activities, and deliverables required to consistently achieve high quality data.
• Experienced in implementing operational plans including data technology, data storage management, and architectural criteria that promote continual data assessment and audit capabilities for security and quality control. Including implementing and testing technical standards for section 508 compliance.
• Experience leading data and reports teams in data management, transformation, analytics and governance with hands-on experience of leading all stages of BI solutions including requirements gathering, definition, preparing Business Process Requirements documentation, design, development, maintenance and support.
• Excellent knowledge in Implementation of Operational data store (ODS), Relational Database (OLTP) and Data warehousing systems (OLAP), Enterprise Data Lakes, Data Marts and CRUD Data process diagrams. Knowledge on Data modeling using Dimensional Data Modeling - Star Schema Modeling, Snowflake Modeling.
• Expertise in Client/Server, 3/n-tier development and service-oriented architecture (SOA), Airflow workflow management, Terraform, AWS. Very strong knowledge in writing and tuning complex SQL, PL/SQL, T-SQL required for ETL, ELT and real-time jobs and fine tuning the workflows.
• Experience in Estimating, scheduling and tracking ETL projects throughout SDLC. Experience in providing plans for an enterprise wide data governance framework, with a focus on improvement of data quality standards and the protection of sensitive data including Experience in Data Modeling of STAR Schema and Snowflake Schema, Physical and logical data modeling using tool like ERWIN, ER Studio and SQL Developer Data Modeler.
• Strong knowledge in building queries on different types of Data Providers like Universes, Personal data files, Stored Procedures, Free-hand SQL, XML files and Web connect.
• Implemented Real Time Change Data Capture (CDC) using various ETL solutions like Talend, SAP Business Objects Data Integrator/Services, Informatica, Talend and migrated metadata from development to production.
• Exceptional experience in administration of various relational databases like Oracle including OID- Oracle Internet Directory, OUD - Oracle Unified Directory, Amazon Aurora, IBM DB2, Teradata, SQL Server, MS Access, Informix, XML and Flat files. Experience with Mongo DB, Lambda, My SQL, DynamoDB, PostgreSQL, Installation, Configuration, monitoring and maintenance.
• Experience of processes like rule extraction, rule analysis, rule flows, and rule base design using ETL tools and complex transformations such as Source Qualifier, Lookup, History Preservation, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Experience in preparing and publishing use-cases, Business process requirements documents and project documentation (user guides, standard report Instructions, and demos).
• Experienced in Relational Data Modeling, Enterprise Data Models, Data Dictionaries, Subject areas, Designing Star Schema, Snow flake Schema, logical and physical data modeling using Data Modeling tools ERWIN, Toad Data Modeler, ER Studio, Ms Visio and Designer.
• Knowledge on Unix Shell Script programming for various background jobs like scheduling.
• Excellent Analytical, problem solving, oral communication and team Lead skills, willing to work in both independent and team environment. Worked closely with database administration team on performance management and backup/recovery.

TECHNICAL SKILLS

Business Intelligence & ETL Tools: Qlick Sight, SAP Business Objects Enterprise, SAP HANA, SAP Business Objects Data Services, SAP Business Objects Data Integrator, SAP Business Objects Data Quality, QlikView, Qlik Sense, OBIEE (Oracle Business Intelligence Enterprise Edition), Tableau, Oracle BI Answers, Oracle BI Publisher, Tableau, AQUA Data Studio, Crystal Reports, SAP Business Objects WebI, Universe Designer, Visual Basic, Oracle Reports, Oracle Data Integrator, Pentaho Business Analytics, Talend, Informatica PowerCenter(Designer, Work flow Manager, Power Connect, Work flow monitor, Repository Manager), Datastage, SSIS, Oracle Warehouse Builder (OWB).

Data Modeling Tools: ERWIN, ER Studio, SAP HANA Data Modeling, Oracle Designer, PL/SQL Developer Data Modeler.

RDBMS: Oracle 12c/11g/10g r2/9i, Amazon Aurora, AWS RDS, EC2, S3, Redshift, Lambda, MongoDB, DynamoDB, PostgreSQL, SQL Server, Cassandra, MS Access, Couchbase, Teradata, IBM Mainframe DB2 UDB.

Languages: C, C++,SQL, PL/SQL, T-SQL, Python, JAVA, MATLAB, FORTRAN, HTML, UNIX Shell Scripting, Scala, Korn and Perl Scripting and UML.

Environment: s Other Tools: AWS, Athena, Solaris, Airflow, Terraform, HP-UX, IBM AIX, STS Data Center, KMS, Ansible, GIT, Eclipse, JIRA, Confluence, Bit bucket, DevOps, DevSecOps, SCT, DMS, Novell NetWare, Linux, Sun-Spark, UNIX, Azure and Windows, HDFS, Splunk, Kafka, Elastic Search, Spark, Map Reduce, Pig, Hive, AJAX, XML / XSLT, Toad, MS SQL Server Management Studio (SSMS), Sql Loader, Hadoop, HDFS, Hive, Jenkins, Apache nifi, Windows TS Client, Toad, VMWare, MS Office, MS Project, MS Visio, MS Share Point, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, NX client, BitBucket, OVM, ASP.NET.

PROFESSIONAL EXPERIENCE

Confidential

Sr Business Intelligence Data Modeler/Architect

Responsibilities:

• Defined and documented the as-is architecture involving extracting financial data from CDFI’s legacy systems and their custom Salesforce application called AIMS. Documented TOGAF phases following DMBOK framework and defined MDM, Data Quality, Data Governance, Data Security and Data Lineage principles.
• Designed data models, data architectural diagrams for extracting, transforming the data from heterogeneous data sources like Salesforce database residing on Ms SQL Server, Excel, Text files, CSV files, Oracle to create financial BI dashboards.
• Conducted Client interviews to gather CDFI’s data warehouse requirements and documented Data Stewardship and data security strategies maintained and expected by the client for their to-be architecture.
• Created documents for SQL coding standards, PII masking and data encryption principles, naming standards and PCI Compliance requirements.
• Created Data Dictionaries, Data mapping templates and design documents and trained the client personnel provide more useful and reliable metadata requirements.
• Extensively used Erwin for creating snowflake based logical and physical data models and implemented reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationship Diagrams.
• Extracted data from multiple complex hierarchies from cross table excel files and created Line Charts to show different trends of finance information over years using set expressions, year function, max() function etc.
• Optimized data loading and performance tuning and implemented security and management of metadata repositories.
• Worked on existing Data Models, changing Load scripts to load data in optimized way to achieve reduction of loading time, simplified complex expressions in the front-end and improved layout structure.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Extensively used QlikSense functions, objects, Set Analysis, Variables to generate different kinds of charts. Also generated QVD files by writing scripts in QlikSense applications.
• Extracted data from multiple complex hierarchies from cross table excel files and created Line Charts to show different trends of finance information over years using set expressions, year function, max() function etc.
• Optimized data loading and performance tuning with the help of Qlik support and implemented security and mobile ability of Qlik Sense QMC, repository and hub access.
• Implemented and designed Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Automated monthly excel reports into Tableau Workbooks and Dashboards and designed Dashboards using Filters, Parameters and Action Filters.
• Designed and Implemented Data warehouse solutions in AWS to migrate data from on premises databases to AWS Redshift, Athena, RDS, ELB, EMR, Lambda, Dynamo DB and S3.
• Implemented AWS Code Pipeline and Created Cloud formation JSON templates in Terraform for infrastructure as code.

Confidential

Lead Data Modeler/Architect/BI/DW

Responsibilities:

• Providing solutions with best practices in software development life cycle, system analysis, Design, Development, coherent with data cleansing, data quality, data conversion, performance tuning, testing, deployment and support as Data SME for the client’s users.
• Leading ETL, Data integration and Data Migration for implementing Enterprise Data Warehouse, Data Lakes, Data Marts across disparate platforms including Oracle, Amazon Aurora, DB2 (Mainframe), Postgres, DymanoDB on AWS EC2, Airflow, Terraform, Oracle Databases on Linux/Unix, SQL Server (Windows), MySQL and other non-standard data sources and flat-files.
• Documenting functional specifications and other aspects for the development of ETL BODI and Talend Batch Jobs with Data Flows and Work Flows using code standards and data security standards.
• Leading Technical and functional aspects of Data Architecture, Design and Reports Development using Business Intelligence solutions, OBIEE, SAP BOE, SAP BODS, Crystal Reports, Tableau, Dashboards, ER Studio, and Erwin.
• Perform full-time coordination as primary liaison between Business and IT on Data Governance, Data Warehousing to provide support of data analysis, mining, data migration and Predictive Analytics.
• Provide supervision of developers and analyst teams performing data migration tasks.
• Implement Operational Data Store (ODS), Relational Database (OLTP) and Data warehousing systems (OLAP).
• Analyze and provide technical solutions using Business Objects Web Intelligence XI R2, ETL Data Services across disparate platforms including AWS, Mainframe, Oracle, SQL Server, MySQL and other non-standard data sources and flat-files.
• Coordinate data mapping sessions with OSHA personnel across the country to review data needs and create mapping and establish the strategy for migrating data between the legacy mainframe, IMIS and the new Confidential systems using JSON for OSHAs State Interface applications.
• Worked with Data Migration applications and directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Responsible for identifying, classifying Personally Identifiable Information (PII) in-terms of sensitivity and security by establishing acceptable usage policy and encrypting PII.
• Involved in production support and tested Data Integrator Batch and Real time ETL jobs.
• Worked and implemented REST API using HTTP requests like GET,PUT,POST & DELETE data on SOAP for agencies to get OSHAs Public Data.
• Lead and implemented Installation, upgrade, migration, patching and cloning of Oracle Databases on Oracle OVM, AWS EC2, S3, Athena, Redshift, Qlick Sight, Airflow, Terraform, Linux, Aix, Hp-ux and Solaris.
• Performed administration of high availability RAC environment, Data Guard, ASM, Golden Gate and implemented on platforms like Linux, Aix, HP-UX and Solaris including migration and upgrade Oracle Databases from older to newer versions.
• Extensively supported and Implemented database logical designs, physical designs & data modeling, planning of backup and recovery using RMAN, Data Pump and Export & Import on Oracle 10G, 11g, 12c, RMAN, OEM Grid Control, Backup and recovery.

Confidential

Sr ETL/Data Architect

Responsibilities:

.

• Analyzing the business specification documents and interacting with business owners and Business Analysts for clarifications.
• Documenting functional specifications and other aspects for the development of ETL BODI and Talend Batch Jobs with Data Flows and Work Flows using code standards.
• Configured ODBC connections to create Data Stores of various heterogeneous Data Sources.
• Developed and designed ETL batch jobs with Talend, SAP Business Objects Data Services/Integrator tool using Oracle 10g/11g and 12c databases.
• Used Data Services Management Console for administration and for Impact and Lineage analysis in the column level of the Sources and Targets, Metadata Reports and for Auto documentation of Workflows.
• Created Organizational reports to continuously monitor data quality & integrity as needed and created Reports, Dashboards and KPIs to be established and rolled out maintaining data quality standards and data management practices.
• Used SAP Business Objects Data Services cleansing transformations for de-duplication, house-holding and address parsing for OSHA’s legacy data.
• Creating complex PL/SQL blocks like stored procedures, views, materialized views and Triggers while implementing complex SQL tuning and query optimization using SQL Trace, DBMS Profiler..
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
• Handling the production build process moving and copying Jobs, Workflows, Dataflows and different Objects and Reusable Objects from local repository to Central repository in a multi user BODI environment using Check in and Check out.
• Designed and developed SAP Business Objects Data Services/Integrator Batch Jobs and Real-time Jobs to load data from Heterogeneous Source systems to ODS and then to Data Mart by loading into staging tables from staging tables data is loaded into relational tables and from Relational tables data is loaded into Dimension tables, Data Marts.
• Used SAP Business Objects Data Integrator XI interactive debugger to test the jobs and fixed the bugs, warnings and errors.
• Analyzed and implemented migration strategies for SAP Business Objects Data Services Batch Jobs, Universes and reports across multiple SAP Business Objects Metadata Repositories (Development, QA and Production).
• Working with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Exported the Universe to the Repository and maintained it with every change in the requirements of the users.
• Working closely with clients to define business and documenting new data requirements that advance the strategies and objectives of the enterprise.

Environment: SAP Business Objects XI 3.1/R2/, SQL, Oracle 9i/10G, Windows Server, Web Intelligence, Apache Tomcat, Salesforce, Java SDK, Erwin,Angular, MATLAB, Python SQL Developer, Scala, Sun Solaris (UNIX), Clear Quest.