PROFESSIONAL SUMMARY:

• A results - oriented information technology services professional having strong analytical and problem solving skills with attention to detail and accuracy. Possess 12 years of comprehensive experience in:
• Designing, developing and implementing data integration/data warehousing/BI solutions for banking and financial services industry (BFSI)
• Developing technology strategies that align with business needs while ensuring that products meet customer needs and corporate goals
• Design data integration solutions that deliver business value in line with the company's objectives
• Subject matter expertise in functional domain of credit card, auto finance and wealth management businesses of banking and financial services industry (BFSI)
• Good experience in agile and waterfall methodologies
• Deep technical knowledge in areas including Linux, UNIX shell scripting, ETL tool (Ab Initio, Informatica) and RDBMS such as Oracle, DB2, SQL Server and Teradata (Utilities BTEQ and FASTLOAD)
• Good experience in handling and understanding various Ab-Initio products GDE, Co-Op, Key Server, Sandbox, EME, BRE, PDL, Data Profiler, Operational Console (Control Centre) and AIR commands.
• Experience in usage of Operational Console (Control Center) extensively for production jobs to analyze the issues and to get the run history, tracking and metrics.
• Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation and L2/L3 production support activities
• Drive the planning, architecture, design and development of software solutions that satisfy business requirements in large complex systems
• Identify alternative solutions to client that support business processes and goals while reducing cost
• Conduct technical reviews and plan for projects implementation in partnership with release management teams
• Participate in establishing / improving IT standards and processes
• Manage project risks in partnership with all project stakeholders by making recommendations for risk mitigation
• Strong time management, priority allocation and task management skills. Proven ability to lead multiple concurrent projects without sacrificing schedule or quality
• Excellent written and verbal communication skills
• Ability to work in a fast paced, cross-functional team environment and within a global collaborative model

TECHNICAL SKILLS:

ETL Tool: Ab Initio (GDE 3.1.5.3, Co>Operating System 3.1.5.7), Ab Initio Configuration Management, Multi-File System, Conduct>IT, Data Profiler, Express>IT, ACE, BRE,PDL, Informatica Power Center 9.1

Programming Languages: UNIX KSH Scripting, PERL Scripting, Oracle SQL,PL/SQL

Databases: Oracle 11g, Teradata 13.10.07, DB2, SQL Server

Operating Systems: UNIX (AIX, Sun Solaris), Linux, Windows

Batch Jobs Scheduler: BMC Control-M Version 8.0, Ops Console

Data Analytics Tools: Hadoop Ecosystem (HDFS) and MapReduce

Version Management Tools: EME, Clear Case and Microsoft Visual Source Safe (VSS)

PROFESSIONAL EXPERIENCE:

Confidential, Dallas TX

Responsibilities:

• Requirements analysis, design, scoping and project estimations
• Perform technical reviews and participate in release management
• Data analysis and source to target mapping creation
• Manage project risks in partnership with all project stakeholders
• Ensure that team adheres to standards and processes for project deliverables

Confidential

Responsibilities:

• Requirements analysis, design, scoping and project estimations
• Perform technical reviews and participate in release management
• Data analysis and source to target mapping creation
• Requirements analysis, design, scoping and project estimations
• Thoroughly analyzed existing EDW functionality that was, in turn, used as input for implementation in ICDW.
• Designed, built and implemented data marts
• Analyzed technical issues and provided resolution for the same
• Performed technical reviews and participated in release management
• Partially executed responsibilities related to project management like managing project risks while working with project stakeholders and senior management and generating dashboard report for review by senior management

Confidential

Responsibilities:

• Analysis, data design, data modeling reviews and build
• Performed design review and code reviews for ETL processes
• Planned and supported implementation of BDS (Broker Dealer Services) applications for the financial conversion

Confidential, NY

Responsibilities:

• Analyze business requirements and convert into technical specifications
• Design, scoping and project estimations
• Perform technical reviews and participate in release management
• Ensure that team adheres to standards and processes for project deliverables

Confidential, Richmond VA

Responsibilities:

• Performed requirements analysis and converted into technical specifications
• Performed analysis, design and build
• Analyzed technical issues and provided resolution for the same
• Closely interacted with various project stakeholders to mitigate project risks
• Performed requirements analysis and converted into technical specifications
• Performed analysis, design and build
• Analyzed technical issues and provided resolution for the same
• Closely interacted with various project stakeholders to mitigate project risks

Confidential, Roseland NJ

Responsibilities:

• Performed requirements analysis and converted into technical specifications
• Performed analysis, design and development of Ab Initio graphs to pull the Data from DCMS application tables, cleanse/transform them according to target layout
• Analyzed technical issues and provided resolution for the same
• Closely interacted with various project stakeholders to mitigate project risks
• Root Cause Analysis of the issues reported in production, provide with the explanation of the issues, work around for the issue and identifying the long term fixes

Confidential

Responsibilities:

• Performed requirements analysis
• Developed batch jobs for front-office and back-office applications
• Analyzed technical issues and provided resolution for the same
• Participated in entire life cycle of SDLC