SUMMARY:

• Possess 16 years of diversified IT experience ranging from Oracle, ETL tools (Informatica /DataStage), Reporting (Cognos), Data Warehousing, Dashboard using Tableau, QTP and Java.
• Experienced in working in an Agile Software development environment with a high Agility Index Measurement for 2+ years.
• Demonstrated leadership, effective communication and project management responsibilities in an Agile environment.
• Contributed and experienced in every aspects of Software Development Life Cycle of a project for 16 years.
• Displayed leadership in areas of collaboration, facilitation, prioritization, risk management, and knowledge sharing for self - organizing teams for 10+ years.
• Passionate about building solutions and finding ways to improve processes by engaging cross-functional teams to achieve business and project objectives for 10+ years.
• Used Data Profiling extensively for 8+ years to validate data to reduce risks and reduce creating reject files
• Experience with Data Modeling for 6+ years in traditional Entity-Relational Model and in Dimensional Modeling
• Implemented security by incorporating Data Governance to modules and users for 4+ years
• Successfully paved the architectural of a re-usable framework using PLSQL to reduce risks by human verification process and execute tasks iteratively in a changing environment by implementing configuration strategy.
• Proficient in Data Extraction, Data Transformation and Loading of data using ETL tools (Informatica, IBM DataStage) and query optimization for 8+ years.
• Experience in developing Data Migration and Data Conversion strategy using IBM Data Stage as ETL for 8+ years and preparing Data Mart for Reporting for 2+ years using Cognos and interfaces using IBM ESB.
• Exhaustive experience in Data Governance and Data Profiling for over 8+ years
• Experience in developing Data Marts and Data Warehouse for Reports by applying Kimball’s Dimensional Modeling and contributing in building efficient queries in Business Intelligence Reports using Cognos/Tableau for 2+ years.
• Worked 8+ years in Oracle 9i, SQL, PLSQL, Unix Shell Scripts, SQL Performance Tuning.
• Experience working in MySQL and Teradata, DB2 and SQL Server for 2+ years
• Extensive experience in developing Web pages using HTML, Java Servlets, JSP and PHP for 2+ years.
• Extensively worked on Visual Basic, Rational Rose for 2+ years,
• Performed Proof Of Concept on recent Java technologies like Spring and Hibernate
• Worked extensively as Test Lead in developing and executing Unit Test Plan, Component Integration Test Plan for 5+ years.
• Develop Testing strategy for System Integration Testing and User Acceptance Testing for 5+ years.
• Experience working with QTP as automation tool and HPQC to track testing results for 3+ years.

PROFESSIONAL EXPERIENCE:

Sr. Data Architect

Confidential, Columbus, Ohio

Responsibilities:

• Provide architectural framework to implement, execute and validate business rules.
• Provide reusable and configurable infrastructure to execute business rules in an iterative manner and store the result of execution for future comparison analysis.
• Provide state-of-the-art design to configure and automate execution and validation of results with least human intervention thereby reducing risks and strengthen customer satisfaction and promote client loyalty.

Service Information De veloper

Confidential, Columbus, Ohio

Responsibilities:

• Design and develop Reports and Interfaces using IBM Cognos, Dashboards using Tableau, ETL using IBM Data Stage helping Tax Analysts to make effective decisions.
• Identify efficient methods of Data Cleansing for Data Quality, Data Extraction, Data Transformation, Data Loading using IBM Data Stage as ETL.
• Performed Data Governance and Data Profiling for Conversion and Reporting.
• Develop the Dimensional Data Model for Data Mart from normalized Data Vault for Reporting using Cognos by extracting data using IMB Data Stage.
• Redesigned the old archaic Conversion process of extracting data from DB2 mainframe into Oracle database for Enterprise Taxation Policy Management (ETPM) using SQL and IBM Data Stage.
• Develop Data Migration and Conversion strategy meeting the requirements to migrate and convert legacy data in DB2 environment into COTS (Commercial off the Shelf) product Oracle Enterprise Taxation Policy Management compliant database.
• Develop plan as per Data Migration and Conversion strategy subject to technical specifications and resource allocation.
• Develop and implement guidelines for DBA to ensure effective Data Migration.
• Develop Unix Shell scripts to automatically execute PLSQLs.
• Develop and review Business Design requirements for Input and Outbound Interfaces.
• Played a pivotal role for the first release of STARS project for the State of Ohio.
• Interacts with the Client and project roles as required, to gain an understanding of the business environment, business rules, technical feasibility and strategic approach for a viable solution in ETPM.
• Improve job performance in Oracle database by partitioning tables, compressing data and creating indexes.
• Develop and maintain Java code in ETPM to implement or enhance business requirements.
• Defines scope, plans, and deliverables for assigned components. Understands and uses appropriate tools to analyze, identify, and resolve business and or technical problems.
• Estimate Fit-Gap analysis and rollout Project Plan estimates based on business requirements
• Provide architecture framework solution overview using ETPM for “Taxpayer Identification” module.
• Apply specialized knowledge to conceptualize, design, develop, unit-test, configure, and implement portions of new or enhanced business and technical software solutions by performing necessary development and QA related activities using HPQC and QTP.

Senior Analyst

Confidential, Columbus, Ohio

Responsibilities:

• Partner with business analysts, developers and production support team to serve as Subject Matter Expertise to identify Report Requirements using BO XI R2.
• Redesign efforts based on business requirement initiatives to streamline activities helping to reduce time and maximize efficiency of resource and overall output using Informatica.
• Improve service turnaround by analyzing workflow and proposing recommendations to business partners.
• Pro-actively seek out additional improvement and standardization opportunities by code review and implementing necessary modifications.
• Display strong skills in Systems planning and project management methodologies.
• Use of personal effectiveness, communication and presentation skills to develop strong client relationship.

Systems Analyst

Confidential, Schaumburg, IL

Responsibilities:

• Query Optimization and Performance Tuning.
• Project maintenance and support.
• Involved in implementing Data Modelling and ETL development activities using Informatica in extracting legacy data in Teradata into Oracle database
• Enhance more business opportunities by developing new business proposals to cater client requirements.
• Design and analysis of business requirements and provide time estimation and resource allocation.
• Determine feasibility for client change request for application executing in Production environment.
• Design, develop, review and test SQL, PLSQL and Unix Shell scripts.
• Review & Execution of User Acceptance Test Plan & verification of test Results.
• Review & Execution of System Integration Test Plan & Test Data & verification of test Results.

Senior Developer

Confidential, Fremont, CA

Responsibilities:

• Demonstrated trial execution of Atesto scripts for Load Test and Site Watch at different client location and provided necessary technical support.
• Designed, developed and test code for parsing the Atesto script using JavaCC parser and transform into suitable objects.
• Designed, developed and test code for objects relating to Load Test and Response Watch using Java SDK 1.4.
• Designed, developed and test to send the output in an XML format from the server to the end user.
• Implemented enhancements based on feedback from various clients to improve the quality of the Atesto scripts catering for most of the clients.
• Implemented shell scripts to monitor the execution of the Load Test and Response Time and to simulate end users from servers scattered in different geographic locations.

Developer

Confidential

Responsibilities:

• Responsible for the architecture of some key modules for city4u.com. Some of which included News & Articles, Matrimonial, E-Greetings, Yellow Pages, Automobile and Hotel Reservation System which had been developed using Servlets, PHP and JSP.
• Was involved in the design, analysis and implementation of the above-mentioned modules.
• Responsible for maintenance of MySQL database and maintenance of the dynamically populated web pages developed in different languages like Java Servlets, PHP and JSP.
• Provided necessary technical expertise in developing dynamic web pages using Dream Weaver.

Developer

Confidential

Responsibilities:

• Designed, developed and test independent modules of the Tax System. This included developing the GUI in Visual basic, execution of the business logic in C++, communicating the C++ object with the Sybase database using CORBA architecture.
• Maintained and updated the design using Rational Rose and generate the necessary skeleton code.