SUMMARY:

• Senior IT professional with over 25 years of IT experience in Data Modeling, Data strategy, Data Analysis, Database performance, Database security, MDM, Data Governance and Metadata management in Fortune 500 companies
• Excellent in designing solutions for Data warehousing and Business Intelligence
• Architected multi - Petabyte Big data / BIDW and high availability transaction processing systems.
• Vast experience on Extraction, Transformation and Loading of data across platforms
• Experience on Meta data definition, implementation and maintenance
• Managed 2-5 million budget projects and achieved project scheduled goals.
• Successfully spearheaded and delivered projects which uses Agile-SCRUM methodology.
• Instrumental in the implementation of process improvement to various organizations, which has substantially increased revenue for the organization.
• Coordinated onsite/offshore teams and served as a single point of contact for offshore team and business stakeholders.
• Held critical roles in various projects starting the career as a Developer and progressively grown to Architect

Strengths & Noteworthy:

• Over 12+ years of experience in ETL, Business Intelligence and Analytics solutions
• Deep domain knowledge in Health Care, Banking, Insurance, Accounting and Taxation
• Extensive hands on experience using MongoDB, Cassandra, Neo4j, Oracle, MySQL and SQL server databases
• Proficient in Informatica, SSIS and Business Objects
• Solid experience in modeling relational and NoSQL databases
• Applied industry standard data modeling techniques to manage NOSQL data as well as relational data
• Skilled in applying data integration, storage and analysis strategy in OLTP as well as Data warehousing environment
• Good exposure to Hadoop and Big data ecosystem
• Excellent understanding of the entire dimensional modeling design life cycle
• Expert in logical and physical data modeling with a deep understanding of developing transactional enterprise data models that strictly meet normalization rules, as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies
• Expert at implementing Physical models using Oracle, SQL Server, MySQL and NoSQL databases
• Proven ability in architecting ETL problems combining data from disparate source systems and disparate data formats
• Very good in identifying bottlenecks of storage and retrieval of data and in improving performance of ETL processes.
• Very good in using Unified modeling Language (UML)
• Excellent Testing skills (Test planning, Test design, Test Execution, Test Reporting and overall Test Management
• Utilizes leadership, communication and interpersonal skills to build teams that exceed goals

TECHNICAL EXPERTISE:

ETL Tools: Informatica 8.x/9.x/10.x, SSIS 2008

Data Quality Tools: Informatica IDQ 9.x

MDM Tools: Informatica MDM 9.x

BI Tools: Business Objects XI 3.1, SSAS 2008, SSRS 2008

Operating Systems: Windows, Linux, UNIX, MVS/ESA

Programming Language: SQL, PL/SQL, T-SQL, Erwin, UML, Shell scripting, Perl, JSON, XML, Java / J2EE, COBOL

Database: MongoDB, Cassandra, Neo4j, Oracle 10g/11g, MySQL 5.6, SQL Server 2008, Netezza, DB2 and Microsoft Access

Domain: Insurance, Health Care, Banking, Accounting, Taxation, Production planning and Child care

Testing tools: QTP, Winrunner, Test Director/Quality center

Scheduling Tools: Autosys, Control-M

Mainframe Technologies: CICS, DB2, VSAM, TSO/ISPF, CSP, JCL, CLIST, REXX, SPUFI

EXPERIENCE SUMMARY:

Confidential

San Antonio, TX

Data Architect

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Interacted with BA’s and SME’sand developed conceptual, logical and physical data model
• Analyzed JAVA code and improved the performance by executing multiple threads simultaneously
• Analyzed DB2 stored procedure and provided recommendation on performance enhancement
• Performed Impact analysis of PPR and identified risk associated with the new functionality
• Implemented Oracle and Informatica Partitioning to boost performance
• Developed Control-M scripts to support automation of ETL and BI jobs
• Developed test strategy, test cases and performed unit and integration testing

Confidential

Data Architect

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Work closely with Enterprise architect, product manager and technical team to develop data architecture for a new banking product
• Reverse engineering the existing MySQL table and created data model for existing product
• Developed Master data management strategies for storing reference data
• Performed data profiling and developed strategies to improve quality of data
• Developed backup and security strategies
• Created and Adopted data modeling standards, techniques and best practices
• Compared relational and NOSQL databases and provided recommendations
• Applied universal data model standard and customized the model as per requirement
• Represented conceptual, logical and physical data models using relational and NOSQL databases
• Developed metadata model for automatically ingesting new entities into the system
• Created logical and physical data model using Cassandra’s model
• Analyzed and identified column families and represented the column families in JSON format
• Applied Web scale store, Flexi schema and highly available store Cassandra design patterns
• Installed, configured and created Cassandra Database
• Used Cassandra Java API to access and store data
• Fine-tuned performance of Cassandra data base by configuring Commitlogs, Memtables and Cache size
• Cleansed the data using Informatica IDQ
• Migrated reference data from existing product into Informatica MDM hub
• Defined procedures and processes for governing Informatica MDM hub
• Expert in developing SQL and stored procedures
• Developed reference data architecture for Analytics
• Fined tuned existing product and improved performance and scalability of the banking product
• Developed test methodology and test strategy

Confidential

Richmond, VA

IT Specialist

Environment: ORACLE, SQL, SQL+, PL/SQL, UNIX, Informatica Powercenter, Informatica MDM, Informatica IDQ, PL/SQL Developer, Visio Professional, PVCS, Business Objects

Responsibility:

• Analyzed user requirements, designed and constructed Computerized Audit selection system. This system is used select audit candidates, evaluate audit performance, prepare statistical analysis, and identify non-filers and under reporters for the major business taxes
• Identified gaps in data requirement between ODS and target applications
• Analyzed source data and identified quality issues and cleansed the data using Informatica IDQ
• Migrated reference data from existing product into Informatica MDM hub
• Integrated data from various sub-systems and loaded into Audit Selection system
• Developed process to extract electronic IRS RAR data and generated reports for Office Audit team using Business Objects
• Automated CARTAX audit process to greatly enhance data turnaround time.
• Fine-tuned performance of ETL process and sessions
• Created universe,Generated reports using Web Intelligence and Desktop Intelligence
• Preparations of test cases for unit and integration testing and performed testing.
• Interacted with project team member regularly to ensure successful completion of the project
• Worked with customers to understand and resolve issues and maintain high level of customer satisfaction
• Maintain database performance by identifying and resolving production and application development problems
• Very good in writing SQL and PL/SQL procedures
• Provided 24/7 production support and maintenance for the applications

Confidential

Data Architect

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Efficiently managed this project from inception until closing
• Mitigate risk associated with operational and technical change
• Define project scope and oversee quality control throughout the project life cycle
• Estimate cost and schedule and deliver within the defined project delivery performance targets
• Translated business requirements and enterprises into long-term Big data architecture solutions
• Applied Bill Inmon and Ralph Kimball methodology and designed Enterprise Data warehouse using Hub and spoke architecture
• Analyzed and defined enterprise master data management strategies and database structures
• Performed the tasks of developing conceptual and logical data models and meta data models (300+ tables)
• Coordinate with business analysts and project managers on a wide range of technology projects
• Identified and eliminated over 100 logical data model flaws that had the potential for extremely costly data inconsistencies.
• Supervised testing activities and ensured the application is tested thoroughly as per the test plan and test cases document
• Prepared training plan and provided training to the client
• Managed staff of software architects, developers and business analysts. Conducted weekly status meetings and reported outstanding issues to senior management.
• Resolved conflicts among team members

Confidential

Data Architect / Project Manager

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Prepared project plan and monitored the status throughout Software Development Life Cycle
• Identified resource requirement and initiated recruitment of resources
• Entire design responsibilities for logical and physical models (200+ tables)
• Designed dimensional model (Confidential) using Confidential methodology
• Created optimized data models for metadata, staging and Data warehouse
• Validated, cleansed and loaded oncology and sales data into SMI
• Designed data strategy for historical and incremental load
• Set design and coding standards, centralizing data modeling decisions, implementing code review and mentoring processes, and leading the database development efforts
• Optimize the physical data model to adequately manage multi-billion row fact tables
• Developed Data flow diagram, ER Diagram,Source - Target mapping document, Pseudo code etc
• Developed mappings, process flow and packages using SSIS (100+)
• Resolved and escalated critical issues to the senior management
• Estimation of work, Prioritization of work, Work assignments, Resource Planning
• Build project team, executed project plan and monitored project status
• Provided Status reports to Management on a regular basis
• Responsible for setting up development and Unit testing environment.
• Worked with customers to understand and resolve issues and maintain high level of customer satisfaction

Confidential

Boston, MA

ETL Architect

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Met with the product management and end-users to organize and define functional and system requirements. Confirmed that requirements and technical design met corporate business and security standards.
• Created use cases to help business customers identify specific system requirements.
• Analyzed source system data model and developed data flow diagrams
• Responsible for designing, organizing, and assessing enterprise database structures
• Defined and maintained best guidelines and standards for metadata, data modeling, and management
• Resolved outstanding development issues, developed implementation plans, provided operational guidelines to business customers, and directed software configuration management.

Confidential

Richmond,VA

Technical Team Leader

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Documented technology roadmaps and the transition from the current architectural framework to target architecture of the future
• Analyzed source system and developed mappings for loading the data
• Applied dimensional modeling techniques for providing rapid response time.
• Identified facts and dimensions and represented using STAR schema.
• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Interacted with project team member regularly to ensure successful completion of the project
• Worked with customers to understand and resolve issues and maintain high level of customer satisfaction

Confidential

Richmond, VA

Technical Team Leader

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Analyzed complex business requirements and identified various data sources.
• Analyzed complex data structures and designed the logical model using Entity-Relationship model.
• Designed physical model and identified tables, stored procedures, surrogate keys, materialized views, bitmap indexes etc.
• Improved performance of the database by creating Range and Hash partitions on database tables and by executing the queries on parallel servers.
• Analyzed complex production data problems and fixed the problems within a very short time span.
• Provided on-call support for various production problems.
• Documented discussions of the team meetings and end-users meeting.
• Provided technical leadership to other team members and analyst.
• Developed test plan and test Scenarios for Unit, Integration, System, Acceptance and Regression testing.
• Developed detailed test cases after analyzing requirement specification, design documents etc.
• Executed the test using test data and recorded the test results.
• Reported the defects using Defect-tracking tool.
• Developed Acceptance test report.

Confidential

Richmond,VA

Technical Team Leader

Environment: Visual Basic, VB.NET, C#.NET, WebServices, ASP, ASP.NET, ADO.NET, Visual Studio .NET, VB Script, Java Script, ADO, C++, SQL, PL/SQL, INFORMATICA, IIS, HTML, XML, XSL, MS Access, MS Excel, Windows 2000/NT, UNIX, Crystal Reports, UML, Rational Rose, ERWIN, Visual SourceSafe, WinRunner, LoadRunner, TestDirector

Responsibility:

• Analyzed the complex web-based system and converted the data using INFORMATICA ETL tool.
• Transformed the data according to the business requirements and then Loaded into Careerlink system.
• Tested the data extracts to check if they conform to business rules.
• Worked extensively on Source Analyzer, Mapping designer, Warehouse Designer.
• Used the command line program pmcmd to communicate with the Informatica Server
• Created indexed, stored procedures and clustered indexes to enhance the performance of the database.
• Attended phone calls from end-users and resolved complex technical problem(s) within very short time span.
• Documented discussions of the team meetings and end-users meeting.
• Reviewed peers functional specs and code

Confidential

Albany,NY

Technical Team Leader

Environment: Informatica PoweCenter 10.x, SQL, Stored procedures, UNIX, Netezza, DB2, Java, Control-M, Agile Scrum

Responsibility:

• Analyzed the complex system in Mainframe and converted the existing legacy system to client-server technology.
• Designed and constructed multi-tier Child Welfare client-server application (ODBC, ADO) using Visual Basic, ORACLE and SQL Server for the State of New York.
• Developed various conversion utilities using VS COBOL II and mainframe utilities.
• Migrated the data in DB2 and VSAM to SQL Server.
• Supported and enhanced the existing legacy system in Mainframe.
• Managed the database development activities involved partitioning the table, creation of stored procedures, triggers, rules, defaults, tables, indexes, etc., on MS Access, and MSSQL SERVER 2000 for these modules.
• Well versed in PL/SQL using all of its features.
• Created and managed Backup, Recovery, tuning and maintenance of database.
• Prepared data flow diagrams and Entity Relationship diagrams.
• Preparations of use cases and test cases for unit and integration testing and performed testing.