OBJECTIVE:

• Seeking a challenging role as a Data Warehouse and Business Intelligence Architect where I can utilize my expertise in the domain and can work in a more challenging environment.

SUMMARY

• More than 11 years of focused experience in Data warehousing, Data modeling and ETL process using Datastage 11x, 8x, 7x, Informatica 8.6 and SQL.
• Experience in multiple domains including Retail Banking, Pharma, Retail, Government and Oil and Gas.
• Experience in managing team of technical resources including members from other vendors.
• Extensively worked with large Databases in Production environments.
• Adequate experience in working in Onsite - offshore model with multi-vendor environments.
• Strong exposure to Client interfacing, Requirement gathering, Business analysis and Team management.
• In-depth knowledge in Datastage parallel job designing.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Datastage
• Proficiency in using Datastage ETL tool to design data conversions from wide variety of source system.
• Extensive work in ETL process consisting of data transformation, Data profiling, data sourcing, mapping, conversion and loading.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Strong exposure in requirement gathering and preparation of high-level design document.
• Hands on Experience in Data modeling using ER Studio and IBM Data Architect.
• Over a decade of IT experience with over four years of technical lead & managerial experience in data warehouse development as Business Intelligence/ Data Warehouse Manager, Architect
• Extensive experience in software size estimation, cost and resource estimation, RFP - proposal writing, due diligence study and preparation of statement of work and project management skills, technical presentation, client liaison
• Architected data warehouse from requirements gathering to conceptualization to creation of data marts using Inmon and Kimball methodologies
• Expertise in Conceptual Data Modelling, Enterprise Data Modelling, Logical Data Modelling, Physical Data Modelling, Enterprise Data Warehouse Design, Datamart Design, Metadata, Data Quality, Master Data Management and Data Governance
• Hands on experience using various ETL tools such as IBM Infosphere Datastage and Informatica
• In depth and thorough knowledge of development and design with RDBMS -OLTP, dimensional modeling using data modeling tool ER Studio. Involved in analysis, development, and migration legacy data and other related database objects with solid experience in Oracle and IBM-DB2.
• Implemented and lead projects at all stages of SDLC. Managed offshore onsite resources
• Excellent documentation skills for database design document, technical design document,
• Engaged by several clients to understand and re-engineer their business processes
• Experienced in various verticals- Oil and Natural Gas, Health Services, Insurance, Finance, Sales and Marketing
• Excellent interpersonal and communication skills.

TECHNICAL SKILLS

Business Intelligence: DATASTAGE 7x, 8x, 11x, Informatica 8.6, ER Studio, Data Architect

DBMS: DB2, Oracle 11g, PL/SQL, Microsoft SQL SERVER, Sybase

Job Function: ETL job designing, Requirement gathering, Client Interfacing, Data Modeling, Client Handling, ETL Design, Coding, Testing, Documentation, Maintenance, Application Support

Languages & Tools: PL/SQL, Citrix, Visual Source Safe, Microsoft Office, DataStage, Cognos, Crystal ReportsXIR2, Informatica 8.6, Control M, Microsoft TFS

OS/Environment: Windows, UNIX, LINUX, AIX, HP UX

Project Methodologies: SDLC, Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Lead/Architect

Responsibilities:

• Interacting with the client to understand high-level requirements for the project.
• Engaging with business analysts to analyze project requirements and determine its feasibility with ‘out of the box’ software capabilities and determine which customizations and enhancements are specifically required for this project precisely for Nebraska.
• Day to day interaction with vendor teams to get development status and following up with stakeholders regarding ongoing issues and challenges (technical as well as operational).
• Holistically maintaining the project timelines for all project activities and aligning the development team with the client business team for addressing any bottlenecks pertaining to requirements.
• Designing the LLD (low level design) and doing the gap analysis from the collected requirement.
• Modeling the data warehouse/data mart as per system’s reporting and expected ad-hoc reporting requirements.
• Preparing the extract logic and mapping documents to load into the data warehouse (DWH) tables with Cúram application as the source.
• Coding of ETL jobs to load into the DWH tables.
• Preparing scripts for audit logging and error handling of ETL flows.
• Conducting code review with customer architect team and closing the CUT (coding and unit testing) phase.
• Following customer’s change control (changing from an earlier legacy to a newer modern system), process to get the code implemented in QA and Production.
• Getting the business approval after UAT for code deployment in production.
• Providing required support during hyper care period after production deployment.
• Providing technical assistance to other team members in case of any issues.
• Providing training to the client to use and generate reports from the tool.

Confidential

Onsite ETL, BI-Data Warehouse Lead

Responsibilities:

• Interacting with client to understand high-level requirements for the project.
• Interacting with customer and vendor teams and other stake holders to address bottlenecks and reporting the status to higher management.
• Documenting requirements in HLD (high level design) document and working with team members to prepare the LLD document.
• Review the Mapping document, source to target document and unit test cases.
• Coding of ETL jobs as per requirements.
• Code deployment and versioning to higher environments using Microsoft TFS.
• Undertaking changes to the existing Data model as and when required.
• Data modeling the new system and modifying the existing data model to accommodate the new reporting requirements.
• Managing a team of five offshore developers.
• Assisting the team during coding and presenting to client in the gateway review meeting before deployment.
• Mentoring the team.
• Providing regular feedbacks to the team members about their work and areas of improvement.
• Distributing the work assignment among the teams based on the workload.