SUMMARY:

• 8.5 years of experience in Application Software Design, Development, Documentation, Debugging and Testing.
• Rich experience in Banking, Financial, Data Warehouse & Metadata Management domains.
• 5+ years of experience in architecting, developing and implementing metadata solutions for large organizations.
• Designed and implemented 3 metadata repositories.
• Experience in working on Business Intelligence tools (ETL) like SQL Server Integration services (SSIS), Metamatrix, Teiid, Kettle.
• Experience in developing database solutions involving Data Warehouse and change tracking with MS SQL Server 2008 & 2012.
• Experience in using many RDBMS like SQL server 2008 & 2012, Oracle 11g, Teradata, DB2, MS Access, Derby, SQL Lite and MySQL.
• Experience in working within the complete software development life cycle (SDLC) collecting business specifications, user requirements, reviewing/auditing the code and documenting the entire life cycle.
• Worked on projects in waterfall and agile methodologies.
• Proficient in enterprise metadata concepts and have deep knowledge on the metadata management & governance processes.
• Worked on Development, Production deployments, Scheduling Jobs, Executing the Jobs, Monitoring, Troubleshooting, Bug Fixing and Production support for various projects.
• Expertise in Production Support projects and Development projects.
• Experience in writing Transactional SQL (Stored Procedures, Triggers and Functions), writing & troubleshooting advanced SQL queries, adept at SQL query performance diagnosis & tuning.
• Experience in analyzing various DQ tools like vendor based - SAS Dataflux, Oracle EDQ and inborn bank tool - CSDR.
• Experience in working on Core Java and J2EE technologies - Servlets, JSP, Java Script, Struts, EJB, Web Services, XML, JDBC.
• Experience in using J2EE Frameworks like Struts, Hibernate.
• Experience in developing Search Engine Architecture using open source search engine - SOLR.
• Proficient in using various IDEs like Eclipse, TOAD, Net Beans, MS Visual Studio and InteliJ.
• Proficient with application servers like Tomcat, Weblogic Application Server.
• Skillful at learning and getting up to speed on any new tool. Have worked on multiple metadata management tools (Metacenter, Informatica Metadata Manager, Adaptive, Thinkmap) and was able to cope up with no training from the tool vendor.
• Experience in Data Quality tool like Drools, Drools Guvnor.
• Strong ability in multi-tasking and adapting to new work opportunities/agile environments.
• Possesses excellent analytical, communication, inter-personnel and leadership skills.
• Adept at working as an individual contributor, or member of a team.
• Experience in working with multiple vendors and geographically distributed teams.
• Have proven abilities working with cross-functional teams, business stakeholders, vendors.
• Strategic thinker, self-motivator, a quick learner, tenacious, proactive and an able mentor.

TECHNICAL SKILLS:

Data Integration tools: SQL Server Integration services (SSIS), Metamatrix, Teiid, Kettle

RDBMS: MS SQL server 2008 & 2012, Oracle 11g, Teredata, DB2, MS Access, Derby, SQL Lite, MySQL

Languages & Scripts: Java, Unix Shell scripts

App & Web servers: Tomcat server, Jetty, Weblogic Application Server

Job Scheduling Tools: Autosys, UNIX Crontab scheduler

Metadata Management tools: Metacenter, Informatica Metadata Manager, Adaptive

Search Engines: Apache Solr

Internet Technologies: J2EE (EJB, Servlets, JSP, JDBC), Struts, Ruby on Rails, Hibernate, Web Services, Ajax, XML, HTML, JavaMail, JQuery, JavaScript, CSS, SOAP, WSDL

Frameworks: Struts, Hibernate

IDEs/Tools: MS SQL Server Management Studio (MSSMS), Eclipse 3.x, Net Beans, MS Visual Studio, InteliJ IDEA, Teradata SQL Assistant, TOAD, Thinkmap (Visualization tool), Textpad, MS Visio, Putty, Filezilla, WinSCP, VI Editor

Data Quality Tools: SAS Dataflux, Drools, Drools Guvnor

Change Management: VSS (Visual SourceSafe), Tortoise SVN

Platforms: Windows 7/XP/2000/ NT, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Application Developer

Confidential, Charlotte

Responsibilities:

• Worked as Onshore Development lead & Developer.
• Understanding the customer requirements and making sure that the solution provided meets the requirements.
• Involved in EDM metadata standards compliance meetings and key discussions on the strategy for Metaportal onboarding.
• Analyzing metadata & Data gaps recorded in the EDIM application and assisting to close out the data gaps.
• Played the role of Data Custodian/Data Steward role for FLUs.
• Developing the DQ solution for defining Rules & managing them for many FLUs.
• Did POC on several vendors based tool like SAS Dataflux, Tosca & Oracle EDQ and inborn bank tool like CSDR.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of the DQ solution.

Application development lead

Confidential, Charlotte

Responsibilities:

• Worked as Onshore Development Team lead - leading a team of 6 developers.
• Understanding the customer requirements and making sure that the solution provided meets the requirements.
• Analyzed data related & Performance issue and fine-tuned the SQL queries for reporting.
• Involved in Metadata Exchange design meetings and key discussions on the strategy for Enterprise wide federated metadata program.
• Preparing estimation of the requirements.
• Attending technical meetings and resolving build issues.
• Designed & developed Complex views, stored procedures, functions etc. using MS SQL Server 2008 & 2012 database for Reporting Purposes.
• Developed many Data Marts for various reporting purposes using SQL Stored Procedures and SQL Server Integration Services (SSIS).
• Implementation of SQL Server Change Tracking of MDEX tables for Data warehouse.
• Performed code configurations using Tortoise SVN.
• Participated in code and design reviews and also used tools for code quality improvements.
• Efficiently managed multiple efforts, lead developers and QA towards project delivery for customers.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Technologies/Tools Involved: Ruby on Rails, SQL Server 2008 & 2012, SQL Server Integration Services (SSIS), Shell scripts, Tortoise SVN, SQL Lite, UNIX, Crontab scheduler, Autosys, Eclipse, IntelliJ IDEA, TOAD For Sql Server, Tomcat.

Application dev lead

Confidential, Charlotte

Responsibilities:

• Worked as Onshore Development Team lead - leading a team of 6 developers.
• Involved in automating the process of on boarding different metadata repositories into Bank’s Metadata Exchange.
• Involved in Metadata Exchange design meetings and key discussions on the strategy for Enterprise wide federated metadata program.
• Preparing estimation of the requirements.
• Attending technical meetings and resolving build issues.
• Design, Coding and testing the automated process for making the extracts available for Metadata exchange.
• Successfully on boarded various types of Data source like RDBMS (Oracle, SQL Server, DB2, and Teradata), Flat files (Text file, Excel file, XML) and Web services into Metadata Exchange. This involved creating transformation mappings to extract the metadata assets from various repositories into the Exchange’s Model.
• Implemented a generic onboarding engine using ruby which connects to various types of Data source like RDBMS (Oracle, SQL Server, DB2, and Teradata), Flat files (Text file, Excel file, XML), process the data and store it in SQL Server. The engine has backend tables to stores the connection details, SQL Queries and other lookup tables which makes it very user friendly.
• Designed and implemented generic approach for storing and generating the SQL Queries which is independent of the Query Languages used in different RDBMS like Oracle, MS SQL Server, DB2, Teradata etc.
• Created tables, stored procedures, functions etc. using SQL Server 2008 database for automating the on-boarding processes.
• Developed many Data Marts for various reporting purposes using SQL Stored Procedures and SQL Server Integration Services (SSIS).
• Scheduled the weekly automated onboarding processes using the Crontab scheduler in UNIX and Autosys.
• Log management and server management using Schell script.
• Efficiently managed multiple efforts, lead developers and QA towards project delivery for customers.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Technologies/Tools Involved: Ruby on Rails, SQL Server 2008, SQL Server Integration Services (SSIS), Shell scripts, Tortoise SVN, SQL Lite, VI Editor, UNIX, Crontab scheduler, Autosys, Eclipse, IntelliJ IDEA, Teradata SQL Assistant, TOAD, Metacenter, Tomcat, Tableau reports.

Developer & Application dev lead

Confidential

Responsibilities:

• Involved in Common model design meetings and key discussions on the strategy for Enterprise wide federated metadata program.
• Suggested the Open Source Search Engine - Solr. Analyzed, designed and implemented the search engine which is very much essential for application which handles millions of data.
• Efficiently configured and customized the Search engine Solr using Master/Slave architecture making it more stable and reliable. Used Multi core concepts which allows the search engine to index multiple sources in parallel.
• Automated the process of on boarding different metadata repositories into Infoportal. Actively participated in requirements gathering, analyzing, designing and developing the data integration Layer using SQL Server Integration Services (SSIS) which connects to various types of Data source like RDBMS (Oracle, SQL Server, DB2, and Teradata), Flat files (Text file, Excel file, XML) and Web services and transform the Metadata from different data model into Common model.
• Designed and implemented generic approach for storing and generating the SQL Queries which is independent of the Query Languages used in different RDBMS like Oracle, MS SQL Server, DB2, Teradata etc.
• Created tables, stored procedures, functions etc. using SQL Server 2008 database for automating the on-boarding processes.
• Developed many Data Marts for various reporting purposes using SQL Stored Procedures and SQL Server Integration Services (SSIS).
• Implementation of SQL Server Change Tracking of MDEX tables for Data warehouse.
• Implemented relationship visualization using Thinkmap tool.
• Scheduled the weekly automated processes using the Autosys Scheduler.
• Implemented Server monitoring programs in Java & Unix Schell scripts.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of a single project.

Technologies/Tools Involved: Java,.Net, SilverLight, Solr, SQL Server 2008, SQL Server Integration Services (SSIS), Shell scripts, Tortoise SVN, VI Editor, UNIX, Autosys scheduler, Eclipse, Teradata SQL Assistant, TOAD, Web services, Hibernate, XML, Metacenter, SOAP, WSDL, Jetty, SpotFire reports, Thinkmap visualization tool.

Developer, Technology Analyst

Confidential

Responsibilities:

• Designed & Developed Metadata Exchange using Data Integration tools - Metamatrix, Teiid, Kettle. Metamatrix is widely used for ETL (Extract Transform Load) operations which connects to various types of Data source like RDBMS (Oracle, SQL Server, DB2, and Teradata), Flat files (Text file, Excel file, XML) and Web services and transform the Metadata from different data model into Common model.
• Designed data quality solution for various source systems and developed a Data quality process using Drools, Drools Guvnor (Rules engine).
• Involved in Metadata Exchange design meetings and key discussions on the strategy for Enterprise wide federated metadata program.
• Actively participated in gathering and analyzing requirements, designing test scenarios and validating the new strategy and tools which helped the business team to complete a proof of concept for the federated program in 2 months’ time.
• Used Hibernate to persist the java objects into the database
• Efficiently managed vendors and ensured on time delivery of the deliverables.

Technologies/Tools Involved: Java, Eclipse, Hibernate, SVN, TOAD, XML, SQL server 2005, Metamatrix, Teiid, Kettle.

Developer, Technology Analyst

Confidential

Responsibilities:

• Automated the complete process to keep the lineages up to date and this closed the audit issue saving lot of manual effort required to create the one time mapping document.
• Developed BTEQ parser to capture the lineages in Teradata queries and leveraged Rochade’s Informatica scanner for INFA mappings.
• Developed a process to connect the 2 pieces from Teradata and Informatica and show the complete end to end lineage.
• Identified the gaps in the process and the accuracy was increased iteratively. Mappings were 80% accurate when the project was delivered.
• Design, Coding and Code Review
• Unit testing and Integration testing

Technologies/Tools Involved: Java, Shell scripts, VI Editor, Autosys scripts, Clear Case, Eclipse, Rochade, Rochade Informatica scanner, SQL server 2005, Struts, Teradata, JDBC.

Developer

Confidential

Responsibilities:

• Made significant contribution throughout the project, right from the scratch and design phase of the project.
• Worked as a developer in building various screens/functionalities for Appointment Scheduling portal and implemented the MVC architecture using Struts
• Configured the WebLogic application server for deployment activities.
• Implemented Forms authentication for security.
• Implemented various web pages with Ajax functionality.
• Worked with Web Server Controls like Drop down List, Hyper Link, Text Box, Check Box, Data Grid, Grid view and Data List etc.
• Worked on creating Web forms, user controls, and Master pages.
• Documented and reviewed the code and process including Quality measures, Test plans and Test reports.
• Designed Database schemes and written database routines like stored procedures, triggers, functions, Indexes and tables using Sql server 2005.
• Used Hibernate to persist the java objects into the database.
• Documentation and User training.
• Used Waterfall method during development process.

Technologies/Tools Involved: Java, Net Beans, WebLogic application server, J2EE Framework - Struts, Sql server 2005, Web services, Hibernate, XML, JavaMail, Servlets, JSP, Java Script.

Developer

Confidential

Responsibilities:

• Worked as a developer in building the Online shopping portal and implemented the MVC architecture using Struts.
• Implemented various web pages with Ajax functionality.
• Worked on Asynchronous programming using JQuery and Ajax.
• Handled client side validations using JavaScript, validation controls.
• Used Hibernate to persist the java objects into the database.
• Design, Coding and Code review and Documentation.
• Used Waterfall method during development process.

Technologies/Tools Involved: Java, Net Beans, JQuery, Ajax, WebLogic application server, J2EE Framework - Struts, Sql server 2005, Web services, Hibernate, XML, Servlets, JSP, Java Script.