SUMMARY:

• Confidential has 15+ years of IT experience with focus on Data Warehousing and Business Intelligence projects.
• Confidential has successfully managed and delivered DW&BI projects across all phases including strategic assessments, roadmap definition, solution definition, design, implementation, and support in many countries.
• His core strength includes Data Integration Design, Development, Data Warehousing, MDM, Data Governance and BI Reporting.
• He has expertise in Ab - Initio, Informatica, Business Objects, and Oracle, Teradata database.
• He has experience of leading team and projects as well as an in-depth understanding of complete SDLC.
• He is proficient in project management, utilizing both onsite and offshore models.
• He has in-depth knowledge of Ab Initio’s most advanced architectural product .
• Confidential is well-organized, calm under pressure and collaborates with individuals, groups and various teams effectively with a high level of professionalism.
• He is self-motivated, open to change.
• He has ability to constructively challenge in a skillfully diplomatic, and respectfully debate.
• One of Confidential ’s strengths resides in his ability to think critically and strategically, cut through complexity, synthesize and articulate complex strategies in a simple, meaningful, jargon-free fashion.

STRENGTHS:

• Information Management/ Business Intelligence
• Financial Services
• International Experience

SKILLS:

• Data Warehouse design, Implementation
• Leadership
• Software Development Lifecycle
• Quality Assurance
• Ab Initio, Informatica, Business Object, Teradata, Oracle, Unix Shell Scripting, Autosys,
• Big Data (Beginner), Hadoop

TECHNICAL SKILLS:

Architectures: Data Warehousing, Multi-Tier, Client Server, Distributed Systems

Databases: Oracle, Teradata, Sybase, MS SQL, MS Access, Rational Clear quest, HP QC

GUIs/Reporting Tools/CASE Tools: Visual Basic, Crystal Reports

Language: C++, HTML - DHTML, Java, Python, Unix shell (korn), Visual Basic

Methodologies : Dimensional Modeling, Star Schema

Warehousing Tools : Ab Initio, EME, Informatica Power Center/Mart, Business Objects

Packaged Tools : SpectrumSCM, Autosys, Visio, Control-M

ORGANIZATION:

Confidential

Ab Initio Lead

Responsibilities:

• Building ground up Enterprise Data warehouse. Setting all environment from development to SIT, UAT and Production.
• Creating a foundation of entire warehouse platform so many new systems can be plud-in easily in future. Achieved this through deploying a Standardized Data Integration Architecture.
• Establish a Transformation Strategy with a focus on specific Data Repositories in each Release
• Deploying a consistent set of metadata, from the System of Record source, through the Data Integration and Data Warehouse layers
• Ensuring compliance of overall design with the enterprise development standards. Guide other developers on technical issues
• Supporting the production rollout and validation activities
• Serving as principle point of contact for any architectural and design consideration
• Improving performance of overall application.

Technology environment: Ab Initio, MDW, ACE, BRE, IBM BDW, Unix, Oracle, Control-M

Confidential, Richmond, VA

Enterprise Release Manager

Responsibilities:

• Coordinating all infrastructure changes and application changes on those environments.
• Single point of contact for changes that impact EDWard environments.
• EDWard environments include development, testing, and production servers.
• If there were infrastructure change/maintenance that occurs on EDWard release weekend, then my team considered that into the release plan and communicated it to all impacted stakeholders.
• Overseeing all release schedules, planning, detail time line and managing Confidential leaderships expectation.
• Gathering information in regard to each change/project and deliver weekly and monthly release report to Enterprise Integrated Release Management group (EIRM/ERM) additional to managing monthly release.
• Reviewing and providing approval for EDWard off-cycle release request that occurs outside already established Enterprise Application Release Calendar.
• Communicating progress of EDWard’s release/deployment to senior leadership team during the release weekend.
• Providing feedback in Enterprise Release Planning meeting to discuss overall issues, mitigation step and enhancement opportunities.

Technology environment: Informatica, Teradata, Unix, Control-M

Confidential, Rosslyn, VA

Project Lead

Responsibilities:

• Lead the effort to access current state architecture; identify gaps, future state recommendations and preliminary implementation plan.
• Identify areas of opportunity to bring down SLAs from evening to morning 10:00 AM.
• Lead efforts of development of Technical Roadmap for Confidential ETL stream.
• Provided various architecture options for a scalable ETL environment to enhance system performance, stability in 4 months of assessment engagement.
• Participated in Code Branching strategy, Error and Reject processing architecture enhancements.

Technical Environment: Ab Initio 3.0.4, Unix, Teradata, Autosys

Confidential, Lanham, MD

Tech Lead

Responsibilities:

• I was involved in assessing Confidential systems facing various challenges in providing timely and quality releases, thus affecting its ability to serve its customers.
• Some challenges exist around lack of robust processes for planning and deploying each release, including end-to-end traceability, design and code reviews, application of leading practices in design and development, etc.
• The objective of the Corrective Action Plan (CAP) engagement is to analyze the existing processes and technical activities, analyze gaps, and provide recommendations for improvements to ensure timely and successful releases.

Technology environment: Informatica, Unix, Oracle, DB2

Confidential, Chicago, IL

Tech Lead

Responsibilities:

• I created entire JSS schedule activity, which includes running all Unix, PeopleSoft, Oracle Stored Procedure and Informatica objects through JSS scheduler.

Technology environment: Informatica, Unix, Oracle, Teradata

Confidential, Warren, NJ

Tech Lead

Responsibilities:

• Analyzed business and user needs, helped in preparing high level design by doing data analysis/profiling.
• Lead offshore team.

Technology environment: Informatica, Unix, Oracle, Teradata

Confidential, Chicago, IL

ETL Designer

Responsibilities:

• Analyzed business and user needs, prepared high level design.
• Designed common reusable component for load, extract and chaining event.
• Directed offshore team in construction and code review to make sure best practice guidelines were followed.

Technology environment: Ab Initio 3.0, Unix, Oracle

Confidential, Warren, NJ

Lead ETL Designer

Responsibilities:

• Analyzed business and user needs, revised existing systems logic difficulties as necessary.
• Defined scope, requirements, and worked with function team lead in Architecture and in tech lead roles to design and architect LGD, LGD to CDM and RWA to CDM processes.
• Demonstrated strong analytical and integrative thinking skills. Manage project execution, monitor and control scope, schedule and resource.
• Aggressively identified project risks. Mitigate issues and risks impacting project delivery with actionable steps to decision makers and resource managers.
• Involved in Prototyping the leading commercial software technology to receive, acquire, transform and load market data into Security Master Central’s (SMC) normalized, integrated data structure.
• Presented key feature of Ab Initio along with other talented consultants, which resulted in winning client trust, confidence and multimillion projects for Confidential .
• Design and constructed a single reusable component to transform all files having multi row, dynamic header and footer.

Technology environment: Ab Initio 2.15, Plan>It, Oracle, Sybase, Unix, Autosys

Confidential

Tech Lead

Responsibilities:

• Involved in Requirement Gathering, Analysis, Design and development. Being an only ETL expert in team I performed dual role of DBA and Data Integrator.
• Designed and constructed Bulk Data Event (BDE) shared routine to read MQ Message Queue continuously and invoking downstream subsystem based on files/message received from queue.
• Designed VDEA MSP subsystem and lead developer team working remotely.
• Effectively communicated with client team (Boston, MA), Business Analyst team (Plano, TX) and offshore development team (Chennai, India) while working remotely (Herndon, VA).
• Well planned activity and co-ordination efforts resulted in delivering entire subsystem well ahead of time, which was running behind the planned schedule.
• Design and constructed many reusable Unix scripts, which were used across the projects.

Technology environment: Ab Initio 2.15, Informatica 8.5, MS SQL, Mainframe, IBM MQ Series (messaging queue), DB2, Unix, Control-M, XML, SOA

Confidential

Project Lead/Asst. Program Manager

Responsibilities:

• Enabled processes to be more efficient, effectively monitor & control engagement revenue for Confidential and Confidential ’s projects.
• Played key role in stream lining monthly Billing Directive process, Engagement estimation, evaluation and revenue forecast process. Maximized benefits/value for HP by timely forecasting revenue, answering client queries, providing various matrixes to management. Lowered risk, resulted from timely, optimized and simplified reporting processes, accurate revenue forecast with most up-to-date information.
• Ensured individual projects are in line with overall HP's management financial plan.
• Owned the business case and worked with senior executives/management to gain support for the business case.
• Effectively coordinated among cross functional teams of EMs, ECOs, Client Principal, Practice Principle, Financial Service Manager, Client CRC team, delivery team, admin staff and so on…

Confidential, Herndon, VA

Tech Lead

Responsibilities:

• Worked on scope analysis, Work estimation, and Operational work model setup. Setup testing environment.
• Performed Stakeholder Management, Scheduling, Resource allocation and Risk management.
• Played key role in implementing the ETL framework and Enterprise Production Framework, which were used across the projects.
• Designed and developed Accounting module of WLCBS. Involved in design and development of many Business Controls, common reusable components, Autosys JIL scripting.
• Designed Common Reject Processing macro, which served as generic component to handle rejects across multiple projects and sub modules.
• Effectively utilized system resource and Autosys feature to parallelized jobs through JIL scripts.
• Collaborated well with cross functional teams ranging from in-house FAST Design/Code Review committee, Business Analyst Team for UAT, ROC team for post development support.
• Mentored team members through presentation and technical guidance.

Technology environment: Ab Initio GDE 1.13.10 & Co-op 2.13.1, HP Unix 11, Oracle, Autosys Job scheduler, Visio, XML, SOA.

Confidential, Richmond, VA

Team Lead/Tech Lead, Onsite Co-Coordinator

Responsibilities:

• As an Onsite coordinator established effective communication channel between project managers, client Confidential and offshore team to discover and prioritize deliverables for Confidential application.
• Delivered analysis factory deliverables, including component narrative and diagram, CRUD matrix, system flow, and Teradata Gap analysis for AMDD application.
• Actively involved in resolving daily production incident, defect and data issues.
• Creativeness and leadership skill resulted in stabilizing 4 TB of database system.
• Participated in enforcing development standards and best practices for development team by conducting design reviews. Mentored offshore developers by providing examples and technical guidance.

Technology environment: HP Unix, Teradata, Ab Initio 1.13, Co-op 2.13.1, Shell Scripting, Control-M.

Confidential

Module Lead/ ETL Designer

Responsibilities:

• Performed requirement analysis, schema modeling, design, developed mapping and work flow.
• Developed highly tuned Informatica mappings
• Designed complex BO universes & resolved “join & performance” issues at the reporting level.
• Created break down report of actual discounts in an invoice and sales order level given to customers.
• Developed customized macro to simplify data comparison, which reduced testing time drastically.
• Mentored junior team members and Conducted interview sessions.

Technology environment: HP-Unix, Oracle 8.1.7, Informatica PowerCenter Designer 6, Workflow Manager 6, Business Objects 5.1.3 and Toad.