SUMMARY:

• Advanced organizing and planning skills to lead large cross - functional teams and complex customer deliverables.
• Expert in Data Architecture, Database design and data modeling.
• Worked in OLAP, OLTP, Data warehouse, and data marts. Expert in SQL Query writing.
• Participated in Data Governance activities.
• Advanced analytical, problem solving, negotiation and organizational skills.
• Agile/scrum methodology.
• Organizational expert within defined subject area.

TECHNICAL SKILLS:

• MS Project, Word, PowerPoint, and Excel, MS Access, SharePoint and MS Project, Oracle,
• Informatica, Unix, Oracle Reports, BI Technologies (Oracle, Business Objects, Tableau), SQL Server, PL/SQL, SQL, Oracle Apex, HTML, CSS, JavaScript, Business Objects, Database Architecture and development, ETL, Java, Reporting and Performance Tuning, Big Data

PROFESSIONAL EXPERIENCE:

Confidential,Boston,MA

Data warehouse Engineer

• Santander Bank is a major bank in Latin America and US. Santander Credit Risk Team is handling all the major credit risk efforts of Santander.
• Worked with all major risk managers in Santander for credit risk application.
• Created data models using ERWIN.
• Defined governance, strategy and roadmap for Data Integration.
• Analyzed the risk Data Warehouse to understand all major issues in the system. Used SQL extensively for analysis.
• Used Informatica to load data; IDQ for data quality and MDM for Master Data Management.
• Worked with Santander and Confidential managers for effective delivery of solutions.
• Wrote SQL Code as part of analysis.
• Informatica PowerCenter, PowerDesigner, PL SQL, SQL Query Writing and Tuning

Confidential,Boston,MA

Data warehouse Engineer

Responsibilities:

• Worked with all the different technical and management people in the organization to understand the existing system and make the necessary change.
• Created efficient ETL programs using Informatica.
• Analyzed enterprise data sources and design integration solutions and architecture.
• Done performance tuning of SQL and PL/SQL programs.
• Prepared test cases and completed unit testing of developed models.
• Analyzed the defects identified by the project team and fixed them.

Environment: Informatica PowerCenter, PowerDesigner, MDM, Oracle, and UNIX and Performance Tuning

Confidential,Boston, MA

Database Engineer

• Conduct Model reviews with project team members.
• Participate in requirements definition, analysis, and design of data related solutions.
• Collaborate with system architects, software architects, design analysts, and others to understand business or industry requirements and for estimation and planning.
• Design databases to support business applications, ensuring system scalability, security, performance and reliability.
• Analyzed and created reporting applications for the client.
• Responsible for interacting with global clients in Wellington Management Company for the enterprise reporting system. Mainly led the development of Investment Administration and Invest Data and Derivative Services section. Additionally in charge of the development and support of IC and DOS Reporting Applications.
• Handled the architecture and development of 1200+ reports working with onsite and offshore teams and maintained a very high level of client satisfaction keeping the management with status reports on a weekly basis; also acted as a liaison between business and technical groups.

Environment: MS Project, Oracle Reports, and PL SQL

Confidential , New York

Informatica Developer

• Worked with different teams from BP, Infosys and TCS.
• Used Informatica PowerCenter and PowerDesigner to load data from source systems to target systems.
• Create conceptual/logical/physical models for staging, data integration and reporting.
• Maintained the repository and exchange of metadata through the various EDW based tools (Informatica, Business Objects, etc.).
• Interacted with business to prepare business case for justifying cost associated with the project.
• Worked with source system analysts to analyze the source system and design the interface with existing data warehouse.
• Interacted with support team members on weekly basis for scheduling and prioritizing work and releases.
• Worked closely with technical team in designing solution for various enhancements.

Environment: Microsoft Project, Microsoft Office, ERWIN, Informatica, Oracle 10g

Confidential,Claymont, DE

Database Architect

• Worked in major Enterprise transformation project as part of HIPAA 5010; worked in 837 standards and Post Adjudicated Claims.
• A major ETL process that extracted key data from Cigna main claim and membership platform called Diamond and Confidential ’s own platform.
• Expert level production & development database administration - all platforms.
• Worked with all technical leads in the organization to understand the existing system and work on the new ETL extract.
• A number of tests are done during the development process to ensure the system meets all business requirements.
• Improved the ETL performance from 12 hours to 2 hours by using tuned queries and optimizing the databases.
• Expert level stored procedures development in Oracle.
• Expert level UNIX shell script development for automating ETL processes, data loads, instance data migration & database or file system backup and restores.

Confidential,Boston,MA

Database Developer

• Oversaw and managed the lifecycle design, development, and implementation of a data capture system supporting a federally-funded program designed to screen all hospital patients for alcohol and drug abuse.
• Interfaced with program staff including IT medical director, senior-level architects, and program managers to understand programmatic needs, learn clinical workflows, analyze legacy systems, and translate needs.
• Led lifecycle activities (analysis, design, development, implementation, testing) of Oracle/SQL-based server site and web application to screen patient status.
• Done database modeling and architecture.

Confidential,Boston, MA

Data Warehouse Developer

• Oversaw and led a healthcare information system optimization project focused on migrating data in order to increase system efficiency and search capabilities for Amisys Advance users.
• Crafted lifecycle project plan; included business analysis, project schedule, and task plan incorporating data analysis, user requirement analysis, system integration, architecture, modeling, and migration activities.
• Managed ETL process design and implementation to integrate data from equipment and production systems.
• Used UNIX scripts and PL/SQL programs to load data into Oracle tables.

Confidential,Boston,MA

Tech and Delivery Lead (Contract)

• Oversaw, planned the design and implementation of a number of Oracle Web Applications, Data warehouse projects for a leading healthcare company in Boston
• Oversaw the lifecycle development activities of more than 25 web-based reporting applications as well as overseeing data warehouse related application development.
• Led the design, development and implementation of an enterprise-level software project (Access and Identity Management).
• Managed both on- and offshore technical development teams to plan and coordinate solution development and project lifecycle from business analysis through testing, implementation, and support.