SUMMARY

• Over 18 years of experience Database designing, development, integration, migration, supporting Data Architect group, Data Governance solutions, Data Management activities using various database technologies in over 7 Government/Federal Projects architecting large data sets, very large data migration including real time data.
• Strong experience in development / maintaining datawarehouses / ETL batch jobs /custom ETL jobs.
• Strong knowledge of Data Modeling ( Conceptual, Logical and Physical Data Model ) and designing / administrating Databases / Data Warehouse using Embarcadero/Erwin/Designer/Power Designer .
• Build and managed three Datawarehouse. Supported Person, Party Role MDM implementation in SBA.
• Provide data architecture, business intelligence, and management consulting in support of various projects; write and present seminars to project managers and development staff to accelerate new technology integration.
• Examine current business functions and suggest strategies for technology development that streamline operations and automate data processes, suggest integration solutions. Perform analysis on current processes, data flow, system analysis and recommended possible TO - BE stage.
• Worked on over 12 data migration projects from legacy to modernization, datawarehousing/ MDM/Data Lake/Dashboarding/ Reporting systems .
• Working in Agile environment since last 7 years .

TECHNICAL SKILLS

Operating System: Windows, Confidential 9000, Debian/RedHat/SCO-UNIX, Sun Solaris

Software/Tools: Confidential Tools (Discover, OWB, ODI, OBIEE), SQA Suite, Toad, MS Office, Erwin, BPMN, JIRA, Bladelogic, Jenkins, Control-M, Alation

ETL Tools: Pentaho Data Integrator (PDI), Informatica MDM 10.1, SSIS, Datastage/QualityStage 11.x, MDM/Data Gov Informatica Axon/Informatica 10.x, Confidential Infosphere 9.1/11.3

Scripting: PL/SQL, SQL*Plus, Pro*C, C, Perl/AWK/Sed/Shell, Python

Databases: Confidential 8i-12c, Sybase, SQL server, DB2, Greenplum, ServiceNow, Redshift, Dashboarding Tableau, QlikView, Cloud AWS, familiar with Azure

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Managing design (Conceptual, Logical, Physical), and Implementation of Agency Wide Strategy for Combined Data Repository (CDR) migrating, integrating, ingesting data from Confidential, SQL server, and many other vendors database migration APIs, working as Prime migration/Integration lead with business decision makers and technology managers.
• Built relationships with business stakeholders and partners to understand information needs, prepared agency wide AS-IS/TO-BE analysis, Data Governance / Data migration Roadmap.
• Implemented a large database solution developed using Confidential, PLSQL, SQL and shell scripts.
• Translated needs into strategy and high-level requirements for Migration / Integration solutions.
• Worked with GSA’s acquisitions/procurements programs supporting Enterprise Architect group to prepare Data Governance strategy for over 100 systems/databases/datawarehouse including FSS19/FMS,PPM/Advantage/IAE/SAM.gov.
• This Task Order includes preparing a security policies around PII systems, establish a lineage between systems, collect all and Key Data Elements, prepare Business Glossary and Metadata Asset List (systems, data dictionaries) and remove redundancy by eliminating systems no longer required or merge where possible.
• Also work to establish a Data Steward group to prepare Data Lake for future state.
• Worked on FMS, PPM migration/integration and prepare plan where replacement systems can be built while existing systems keep on functioning as required.
• Also worked on Data Management Plan including policies on who will be owner of data and how Data Elements can be shared within GSA, across agencies.
• Enhanced data models by developing integrations with business partners.
• Built the infrastructure required for the aggregation of data from a variety of sources.
• Created analytics tools that utilize the data pipeline to provide data insights using Alation (Data Catalogging tool).
• Extensively worked in the different areas of the data connector life cycle including worked on initial data integration and completeness analysis, also worked on data quality and analytics around connector
• Working with technical subject matter experts (SMEs) to identify and refine data requirements
• Working closely with the various vendors, Database groups and technical team to convert requirements into design and migration steps.
• Working with customer SME’s and senior leadership to ensure systems requirements are met during migration and integration.
• Define enterprise information strategy and technology roadmap that aligns with Confidential goals and CTO vision.
• Supervise Migration roadmap implementation across the enterprise as required by development teams and business stakeholders.
• Own the Migration process and associated management platform.
• Participate in the data governance process as a member of the enterprise data council.
• Define data quality strategy and oversee implementation for key datasets.
• Work with vendors, cross products, stakeholders, Admins staffs by creating appropriate requested and gets required approvals.

Confidential

Database Architect

Responsibilities:

• Worked with DOT OCIO Data Governance group. Managing, designing and implementing Cloud Migration of over 31 O n-Premise databases/datawarehouses.
• Created Redshift Data Lake, Data Stewardship roles, SOPs, AS-IS/TO-BE analysis, Data Quality (DQ). Design, develop and implemented database algorithms such as classifications, pattern recognition.
• Identify and develop opportunities to build compelling proposals to help customers achieve business value from migrations to Redshift Data Lake, provide the path forward for customers to build migration plans and business cases, and ensure clarity on AWS’s value proposition(s) for the customer as they move their workloads to AWS.
• Build and manage reporting mechanisms to capture results and improvement opportunities.
• Periodically present progress to executive leadership.
• Defined optimal design patterns and solutions for high availability and disaster recovery for applications.
• Defined optimal design patterns and solutions for cloud migration programs for medium and large enterprises.
• Drove scope definition, requirements analysis, functional and technical design, application build, product configuration, unit testing, and production deployment.
• Ensured delivered solutions met/performed to technical and functional/non-functional requirements.
• Provided technical expertise and ownership in the diagnosis and resolution of an issue, including the determination and provision of a workaround solution.
• Ensured delivered solutions were realized in time frame committed; worked in conjunction with project sponsors to size and manage scope and risk.
• Provided support and technical governance, expertise related to cloud architectures, deployment, and operations.

Confidential

Data Architect

Responsibilities:

• Build a MDM hub Dashboards using Informatica, designed over 16 ETL process, worked with various units on large realtime data manipulations project including data manipulation being done to bring data and store in MDM, and to be presented/provided from MDM. Ensures that MDM data is assured and validated by automated processes.
• Builds and maintains temporary databases and data structures necessary to analyze and troubleshoot issues with current and planned data sources.
• Analyzes and evaluates incoming data from disparate data sources to inform data modeling and ETL design decisions for large data integration projects.
• Interprets data linkages, hierarchies, sequencing, and nuances in new data sources.
• Design, developed complex data modeling and database design and development efforts.
• Ensures that the MDM team retains proper data domain knowledge across data and business analysis resources.

Confidential

Data Warehouse Architect

Responsibilities:

• Involved with design and development of algorithms for failed Banking institutions so data can be mined and future failures of institutions can be prevented.
• Extensive experience merging multiple databases, dimensional data modelling, designing ETL solutions for complex, multi-source data warehouses.
• Performs analyses and data modelling (Logical, Physical ERD), Process Flow, development and evaluation of data mining in a data warehouse environment, metadata and repository creation. Developed data mining and data analysis tools with custom codes in PL/SQL.
• Reviews data loaded into the data warehouse for accuracy, writes scripts for Load, Transform, Validation. Interacts with users/SME’s and responsible for preparation of scope, system requirements, analyses and design throughout the development, data Loading, QA, implementation.
• Supervised and work with 10-12 team members .
• Liaised to User/business managers for Data Governance, technology transfer, provide data architecture, business intelligence, and management consulting in support of various projects; managing ongoing strategy, obtaining requirements, and streamlining the enhancement/defect prioritization; Project planning, scopes & estimation, Deployment planning and coordination between User/Technology dept., team assignments; Recognized as primary leader to triage and resolve critical/daily issues; Oversaw personnel hours, budgets and development cycle for team members, Reported all results and status updates for risk assessment.

Confidential

Sr. Database Engineer

Responsibilities:

• Thomson Financial is the premier database related product based company in the Financial and mutual fund area.
• During this tenure, Involved in transforming data requirements into enterprise data architectures and data warehouse architectures by creating Logical Data model and then converting into physical model, Also involved in the Design/Development of in-house developed ETL tool using Unix and SQL/PLSQL .
• I also worked on Data Modelling including Logical Data Model using Designer 9i tools as ER-Diagrams, Functional Hierarchy Diagrams, Server Module Diagrams, I was responsible for Designing, Developing code, debugging in Confidential 11g using Toad and PL/SQL, my job also required Performance tuning or change legacy processes to use latest Confidential function to enhance performance.
• Also managing Confidential Application Servers with Confidential Forms, Reports, Discoverer applications, I have to develop and setup Cron Job/ Unix shell scripts on Sun Solaris, as our development teams spread over three continents I have to support Change Management including merge/labelling and promote changes we are using Visual Studio /Team Foundation server/VSS for change management.
• Using Informatica to load data from various sources, extensively involved into Designing of legacy ETL/ELT migration to Informatica and used various transformation methodology, My job at Thomson heavily involves redesigning / restructuring / converting legacy database systems to Confidential RDBMS whenever new clients acquired/merge by Confidential .