Project Sql Server
Resume:
Arun Kumar
980-***-**** *** Candler lane
****.*******@*****.*** Apartment 1217
Charlotte, NC 28217
Objective
Seeking a challenging - Technical lead position that can utilize my
excellent analytical, designing, technical and leadership skills acquired
through 5 years of my professional experience and knowledge in software
field.
____________________________________________________________________________
________
Education
June 2006 Bachelor of Engineering in Computer Science
. Madras Institute of Technology, Anna University, Chennai, Tamil Nadu,
India
Overall GPA: 7.6/10
____________________________________________________________________________
________
Summary
. Over 5 years of experience in Application Software Design, Development,
Documentation, Debugging and Testing.
. Experience 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 Development, Production deployments, Executing the Jobs,
Monitoring, Autosys Scheduling, Troubleshooting, Bug Fixing and
Production support for various projects.
. Strong skills in Core Java ( JavaCC, Multi-threading, Collections API-
Data Structures), Java Servlets, JSP, Struts, EJB, Web Services, Java
script, XML, XSLT, JDBC.
. Experienced in using Frameworks like Struts, Hibernate and Junit.
. Proficient in enterprise metadata concepts and have deep knowledge on the
metadata management and governance processes
. Skillful at learning and getting up to speed on any new tool. Have worked
on multiple metadata management tools (Rochade, Metacenter) and data
integration tools (Metamatrix, Thinkmap) in the last 4 years and was able
to cope up with no training from the tool vendor.
. Experience developing database solutions with Oracle 10g and MS SQL
Server 2005.
. Worked on search engines - SOLR and GSA (Google Search Appliance)
. Worked on Windows NT/2000/XP, UNIX, LINUX, Solaris Operating systems,
Microsoft office products, MS Project.
. Proficient in using various IDEs like RAD, WSAD, Eclipse.
. Proficient with application servers like WebSphere (WAS), Tomcat.
. Experience using version control tools like VSS, Subversion and Rational
Clear Case
. Expert in Production Support projects and Development projects.
. Possesses excellent analytical, communication, inter-personnel and
leadership skills.
. Adept at working as an individual contributor, or member of a team
. Strategic thinker, self motivator, a quick learner, tenacious, proactive
and an able mentor
. Have proven abilities working with cross-functional teams, business
stakeholders, vendors
. Proven abilities in issue tracking, issue resolution, troubleshooting and
problem solving
. Strong ability in multi-tasking and adapting to new work
opportunities/agile environments
Technical Skills
Internet Technologies : J2EE (EJB, Servlets, JSP, JDBC, JavaMail), Struts,
Hibernate, Springs, Web Services, XML, HTML,
JavaScript, CSS
Frameworks : Struts 1.2, Hibernate 2.0, JSF
Languages & Scripts : Java, JavaCC, Unix Shell scripts and Autosys
App & Web servers : Tomcat server and WebSphere
RDBMS : Oracel9i, SQL server 2000 and MySQL
IDEs/Tools : Eclipse 3.0, WSAD 5.1, Textpad, MS Visio, Toad, Putty,
Filezilla, Autosys, Microsoft live meeting,
Thinkmap (Visualization tool)
Metadata Management tools : Rochade, Metacenter
Data Integration tools : Metamatrix (Red hat)
Search Engines : SOLR, GSA
Change Management : VSS (Visual SourceSafe), Clearcase,
Subversion
Platforms : UNIX, Windows 9x,XP
Professional Experience
Bank of America, Charlotte May 2010 -
till date Senior Developer and Team Lead
MDEX Automation and Development
This project is to automate the processes involved in on-boarding different
repositories and also implement different visualization models in the
portal using Thinkmap tool. Analyzed different metadata repositories and
identified the best approach to extract the data from source repositories
and make it available for Metadata Exchange. Few repositories were
persisted due to performance issues and developed weekly automated
processes to extract the delta dump from source. Completed the onboarding
on schedule though analyzing the new metadata repositories was a big
challenge and has also provided value adds by implementing SQL gen tool for
generating the Metamatrix mapping queries. Currently working on Report
Engine which constructs the query XML and gets the report as CSV result set
from Metamatrix.
Responsibilities:
. Working as the Onshore Development Team lead - leading a team of 5
developers in a rigorous Agile project.
. Involved in automating the process of on boarding different metadata
repositories into Bank of America's Metadata Exchange.
. Successfully on boarded EMIP (Rochade), Metacenter and Brownstone
metadata repositories into Metadata Exchange. This involved creating
transformation mappings to map the metadata assets in the repositories
into the Exchange's Common Model.
. In depth knowledge on Rochade and its metamodel helped in the
successful on boarding and generating the extracts out of Rochade.
. Implemented relationship visualization using Thinkmap tool
. Attending technical meetings and resolving build issues.
. Design, Coding and testing the automated process for making the
extracts available for Metadata exchange.
. Efficiently managed multiple efforts, lead developers and QA towards
project delivery for customers.
Environment: Java, Springs, Web services, Hibernate, Shell scripts, VI
Editor, Autosys scripts, Clear Case, Eclipse, TOAD, XML, Rochade, Thinkmap,
Metacenter, SQL server 2005, Metamatrix, SOAP, WSDL, Tomcat
Bank of America, Charlotte May 09 -Apr
2010 Senior Developer
MDEX Design and POC
Metadata exchange is Bank of America's federated metadata management
strategy that reaches into line of business metadata repositories to
retrieve, search and report data.
Metadata repositories are external to MDEX and data is onboarded using
Metamatrix tool. Metamatrix is used to capture/design virtual models of its
physical data sources and data is structured/transformed into a common
model (Carbon model) that is able to describe all metadata. Implemented
SOLR search engine which is capable of searching using exact phrase,
exclusionary, logical operators. SOLR is a standalone enterprise search
server which applications communicate with using XML and HTTP to index
documents, or execute searches. SOLR is the search engine behind the larger
MDEX system.
Responsibilities:
. Involved in Metadata Exchange design meetings and key discussions on
the strategy for Enterprise
. 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.
. Implemented Metadata Exchange using Data Integration tool and portal
search using SOLR search engine which were the 2 key components for
the federated metadata program.
. Identified poor data quality from the source systems and developed a
Data quality process using Rules engine
. Used Hibernate to persist the java objects into the database
. Efficiently managed vendors and ensured on time delivery of the
deliverables.
Environment: Java, Eclipse, Hibernate, SVN, SOLR (Search engine), TOAD,
XML, SQL server 2005, Metamatrix
Infosys Technologies, India Oct 08 - Apr
09 Java Developer
Sustainability Plan
This project involved developing automated tools to capture the data
lineages based on code (BTEQs and INFA mappings). Requirement was to create
a sustainability plan to capture the updates on top of the current metadata
based on the changes happening in each application. The documented
metadata mappings for data elements were inaccurate and this project
remediated the source to target mappings based on the Teradata queries and
INFA mappings. As part of this BTEQ parser was developed which would parse
the teradata queries and identify the source and target information from
the insert queries. Also leveraged the Rochade Informatica scanner to parse
the INFA xml and produce its source and target mappings. The BTEQ and INFA
lineage pieces were linked to show the complete data lineage from system of
record and this data was made available in the metadata portal. This has
been setup as an automated monthly job which would identify the modified
components and update the existing lineage accordingly.
Responsibilities:
. Developed automated parsers to capture the source to target mappings
and the transformations from the BTEQs and Informatica mappings
. 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
Environment: Java, JavaCC, Shell scripts, VI Editor, Autosys scripts,
Clear Case, Eclipse, Rochade, SQL server 2005, Informatica, Struts,
Teradata
Infosys Technologies, India Aug 06 - Sep
08 Java Developer
Enterprise Metadata Information Portal
This project is implemented to provide access to business, semantic and
technical metadata across Global Human resources technology and the
Enterprise Information management LOBs within Bank. Rochade was used as the
metadata management tool and EMIP portal was built on top of it as an
intuitive user interface. This project involved designing of metamodels
(Rochade Information model) to structure and syntax the information stored
in the repository. Developed the functionalities for the portal using
Struts and also implemented the search functionality using Google search
appliance. It also involves design, development and deployment of various
initiatives like Customer reference data in EMIP, AML, User Administration
and I was also involved in support activities and user training. Developed
disaster recovery process to back up the Rochade databases and save a copy
of it contingency server. Actively involved in designing the metadata
governance processes to make sure that the metadata in repository is up to
date and the old metadata is decommissioned.
Responsibilities:
. Worked as a developer in building a metadata portal and implemented
the Enterprise Metadata Information Portal using Struts
. Configured the Teradata and Oracle Rochade Scanners to retrieve the
technical metadata from different sources and store it in Rochade
databases
. Designed processes for uploading and maintaining operational and
business metadata
. Implemented metadata governance policies around the portal and this
was the first successful metadata portal in Bank
. Integrated the portal search with Google Search appliance
. Design, Coding and Code review
. Documentation and User training
. Application support
Environment: Java, Shell scripts, power broker, VI Editor, Autosys
scripts, Clear Case, Eclipse, Rochade, Struts, Teradata, Rochade scanners
crontab, JavaMail
Infosys Technologies, India May 06 - Jul
06 Programmer
Employee Timesheet system
This system is developed as an internal project for Infosys to manage
employee details and employee attendance. This will be system of record for
time tracking and resource management. This will have snapshot of every
employee and generates various reports based on department, project and
time period. The main focus was given to employee tracking, accounting,
time keeping and general management. User interface is developed using Java
Applet, and Oracle as a database.
Responsibilities:
. Involved in system analyze, design requirement gathering.
. Developed the Front-end using JSP and JavaScript to present the server
response and client side validations.
. Involved in database design with Oracle and used the JDBC connections.
. Prepared and executed the Test Cases for whole application.
. Involved in Application deployment and maintenance.
Environment: Java Applet, Servlet, Apache Web Server, HTML, DHTML,
JavaScript, Unix and Oracle.
Lokeshvar.Iyanar
2
Contact this candidate