Project Data
Resume:
OBJECTIVE:
TO PURSUE A CAREER AS A SENIOR SOFTWARE ENGINEER BASED ON 10 YEARS OF
EXPERIENCE IN THE FIELD OF I.T. IN A GROWTH ORIENTED ORGANIZATION THAT WILL
OFFER CAREER DEVELOPMENT AND ADVANCEMENT OPPORTUNITIES UTILIZING MY STRONG
TECHNICAL SKILLS.
PROFESSIONAL SUMMARY:
. Experience leading team for process on critical projects with tight
deadlines. Have a successful track record of delivering high quality
deliverables.
. Strong development and testing skills especially in Informatica, Oracle,
Sybase, shell scripting, perl scripting and backend objects.
. Extensively worked on software agile technology.
. Strong Project management, Release Management, Database Development, Data
warehousing and Software Engineering background.
. 10 Years of IT experience in management and development and design of
ETL methodology for supporting data transformations and processing in a
corporate wide ETL Solution using Informatica PowerCenter 8.1/7.1/6.2..
. Proven track record in planning, building, and managing successful large-
scale Data Warehouse and decision support systems. Comfortable in both
technical and functional applications of RDBMS, Data Mapping, Data
management, Data transportation and Data Staging.
. Extensively worked on databases like Oracle 10g/9i/8i, Sybase, DB-2.
. Proficient in coding using SQL, PL/SQL, iSQPlus, TOAD, Rapid SQL
procedures/functions, packages, triggers, Explain Plan, Constraints,
Triggers, Indexes, Views, Inline Views, Database Links, Export/Import
Utilities.
. Experience working with XML schema.
. Experience in writing UNIX shell scripts and PERL scripts to support
and automate the ETL process.
. Experience scheduling jobs using Autosys, Control M and informatica.
. Profound Knowledge of SDLC and STLC. ( Agile, Waterfall) Experience in
developing Test cases, developing Test scripts and analyzing bugs.
Knowledge in Manual, Black Box Testing.
. Experience on automation builds using Rational Build Forge, Anthill
Pro, Udeploy, Hudson, ANT and GANT.
. Good communication, client interaction, problem solving and
interpersonal skills.
CERTIFICATION:
INFORMATICA CERTIFIED DEVELOPER: SUCCESSFULLY COMPLETED POWERCENTER 8
MAPPING DESIGN EXAM. APRIL 2008
Education:
MASTER OF SCIENCE IN COMPUTER ENGINEERING- CALIFORNIA STATE UNIVERSITY,
CHICO, 2005-2006
Bachelor of Engineering in Electronics and Communication- Sardar Patel
University, Gujarat, INDIA, 1997-2001
technical skills:
ETL TOOLS INFORMATICA POWER CENTER 9.1/8.1/7.1 (REPOSITORY MANAGER,
DESIGNER, WORKFLOW MONITOR, WORKFLOW MANAGER, POWER MART 5.X,
STAR & SNOWFLAKE SCHEMA.
DATABASES ORACLE 10G, ORACLE 9I/8I, SYBASE, MS SQL SERVER 2000/7.0.
DATA MODELING PHYSICAL MODELING, LOGICAL MODELING, RELATIONAL MODELING,
DIMENSIONAL MODELING (STAR SCHEMA, SNOW-FLAKE, FACT,
DIMENSIONS), ENTITIES, ATTRIBUTES, CARDINALITY, ER DIAGRAMS,
ERWIN 4.0/3.5.2/2.X. OLAP
MISCELLANEOUS TOAD, RAPID SQL,SQL*PLUS, SQL SERVER QUERY ANALYZER, SQL SERVER
TOOLS ENTERPRISE MANAGER, AUTOSYS, ASSET CONTROL DESKTOP 3.1,QUALITY
CENTER, HUMMING BIRD, ALARM POINT, SERVICE CENTER, PACE, RESULT
SPACE, SCOPEMETER, RTC, CONTROL M, MS VISIO, MS PROJECT
GENERAL SOFTWARE C, C++, JAVA, UNIX, SHELL SCRIPTING, PERL, SQL, PL/SQL, EXCEL,
& PROGRAMMING WORD, POWERPOINT, MICROSOFT PROJECT, MICROSOFT VISIO, HTML,
TCP/IP, NETWORKING
OPERATING WINDOWS 7, 2000/98/XP/NT, UNIX (SUN SOLARIS AND AIX), LINUX
SYSTEMS
BUILD/RELEASE IBM RATIONAL CLEAR CASE, IBM RATIONAL SOFTWARE BUILD FORGE, ANT
MANAGEMENT AND GANT, GITHUB, HUDSON, JENKINS, ANTHILL PRO, UDEPLOY
SOFTWARE
PROFESSIONAL EXPERIENCE:
COMPANY: FIDELITY INVESTMENT, MERRIMACK, NH DURATION:
JAN 2013 - CURRENT
Title: Project Manager Project: SMSV
SMSV-Intrepid provides enhanced data management capabilities to the
Fidelity Institutional Operations Team. SMSV-Intrepid will allow for the
ingestion of more granular reference data to support the increasing needs
of institutional clients and customers. The system will also provide
proactive identification of vendor data exceptions and an integrated
business process workflow for researching and resolving the exceptions
using both IDC and Bloomberg data.
RESPONSIBILITIES:
. Delivered initiatives on-time and within budget using an agile
development methodology
. Managed project change control process
. Developed strong, collaborative relationships with key IT and business
partners
. Prepared for, facilitated, executed, and followed through on various
project meetings
. Designed Environment Strategy for SMSV projects.
. Designed and Developed Polar lake loader to load Bloomberg and
vendors.
. Designed Release Management Strategy for SMSV project.
. Analyzed and Requested hardware required for project.
. Work with Business Analyst to collect project requirement.
Company: Fidelity Investment, Merrimack, NH Duration:
Aug 2010 - Dec 2012
Title: Senior Software Engineer/Release Engineer Project:
INTREPID
The International Repository of Investment Data (INTREPID) will replace the
existing Global Reference Database (GRD) and tools with a new reference
data system that will provide DMS (Data Management Services) with data
acquisition, management, and distribution capabilities in support of the
future state vision. The Asset Control (AC) software was acquired to serve
as the core of the new reference data environment and be extended as
needed. Migration to the new INTREPID environment will be a multi-year
effort that aligns delivery of value-add services with continued support of
existing services.
RESPONSIBILITIES:
. Lead and managed Infrastructure team.
. Developed strong, collaborative relationships with key IT and business
partners
. major and minor releases, patches and/or critical fixes (including
versioning and code deployment)
. Plans for external release, identifying key activities leading up to,
during and after releases to higher environments
. Responsible for writing, maintaining or testing deployment scripts
and/or installation and configuration processes
. Optimizes deployment processes to minimize manual intervention,
minimizing deployment risks and timeframes
. Developed an automated, continuous, build process that reviews the
source code, identifies build errors and notifies appropriate
development team to expedite/facilitate synchronization to the latest
positive build.
. Responsible for assisting development team to prototype build and
release automation tools.
. Developed Data Acquisition loaders using Polar Lake Framework.
. Extensively worked on XML schema.
. Developed Informatica loaders to load Bloomberg vendors.
. Designed loaders for Markit, PDS, GICS and ratings vendors.
Environment: PolarLake, Java, Spring Batch, TCS, Oracle, XML, Shell,
Informatica
Company: Fidelity Investment, Merrimack, NH
Duration: Nov 2007 - July 2010
Title: Senior Database Developer Project:
Holdings Hub
The Holdings Hub is a platform which represents the centralized aggregated
holdings information of portfolios and funds. Source data for the system
includes fund accounting (FOCAS, FOCAS Money Market, FIL Invest1, FPMCMS
and Mig ), Corporate actions ( Focas and FPCMS), Pricing System (GPWC,
other accounting sources and trading systems), trading ( Fixed Income,
Equity, Pyramis, Escrow ), GRD, Security References etc. The output of
the holdings hub is an ODS and warehouse database schema as well as a small
set of flat files (for specific down-stream system consumption). Data is
loaded into the system through numerous Informatica, Transformation Server,
and stored procedure processes. A GIM (GLOBAL INVESTOR MANAGEMENT) process
that applies all the positions, trades, corporate actions, etc. as part of
the application data generator, the result of which is the positions for
the next trading day given a particular view.
RESPONSIBILITIES:
. Worked with BA to analyze business requirements.
. Created architectural design for applications.
. Lead and managed project team.
. Worked with GIM (GLOBAL INVESTOR MANAGEMENT) team for understanding GIM
product.
. Analyze PENSETS -grouping of logical transaction used by GIM product.
. Used transformation server to track real time trading data.
. Extensively worked on infomatica to implement business logic for
Holdings Hub.
. Studied the existing OLTP system(s) and Created dimensions and star
schema representation for the data mart.
. Analyzed and created Facts, Dimension tables.
. Extensively worked on the Database partition for warehouse schema,
Cursors, Triggers, Functions and Database Constraints.
. Developed PL/SQL code using the Business specifications.
. Worked with QA team and Business team in functional testing.
. Provided on call support for application.
Environment: Informatica, Oracle, Perl Script, Shell Script, Autosys
Company: Fidelity Investment, Merrimack, NH Duration: Mar
2008 - Dec 2008
Title: Senior Database Developer Project: IDW (Investor
Data Warehouse)
IDW is the primary, centralized data source of current and historical
transaction information. Data is loaded into the system through numerous
Sybase Stored procedures, transformation server, Informatica, Perl Scripts,
shell Scripts and autosys. IDW contains trade history since 1996, current
day trading information loaded 6 times day daily, Holding data like
Beginning of Day UK security and fund-level holdings, fund net asset,
Reference data(Securities, issuers, brokers, funds) and supplementary
trade and reference data like settlement data, failed trades, approved
broker lists, trading desk assignments, new issues.
Responsibilities:
. Single point of contact for design and development for IDW.
. Involved in creating technical documentation for the project.
. Designed procedures for getting data from multiple systems to Data
Warehousing system. The data was standardized to accommodate new pyramis
trading data.
. Used transformation server to track real time trading data.
. Designed stored procedures for loading data from transformation server
to investor data warehouse. Extensively worked on the Database Cursors,
Triggers, Functions and Database Constraints.
. Analyzed existing OLTP system(s) and created facts, dimensions and star
schema representation for the data mart.
. Used Sybase stored procedures extraction, transformation and loading
data from heterogeneous source systems
. Designed logic for roll marker to load all trades to ware house before
deleting any trade for that business day.
. Designed PERL scripts to call Sybase database stored procedures.
. Designed, Developed, Reengineered and fine-tuned Sybase Stored
Procedures and triggers.
Environment: Informatica, Sybase, Perl Script, Shell Script, Autosys
Company: Fidelity Investment, Merrimack, NH Duration: Nov 2006 - Mar
2008
Title: Senior Database Developer
Project: FMS2(FEED MANAGEMENT SYSTEM 2)
FMR2 is designed to strengthen the oversight and administration of data
feed management (IFeeds) and provide a service that is efficient,
centralized, controlled, auditable and secure, the Feed Management System
(FMS) is needed to collect feed metadata, setup new feeds/update existing
feeds on the iFeeds file servers, collect log activity, and provide
reporting. Sources are flat files ( ifeed server data), informatica is used
to process data and target is oracle database.
Project: INTEGRA (DRM Workstation) and EARL (DRM Bulk Loader)
The DRM Workstation development project consists of three phases involving
Informatica loaders in support of workflow management, and a fourth,
"middle-tier" verification phase which does not involve Informatica. This
middle-tier process verifies reply data from Bloomberg and updates several
of the oracle tables controlling workflow. DRM is requesting a bulk load
security set-up process which will add securities in a fully automated
manner onto the GRD. The new process will significantly decrease the time
it takes to add large quantities of securities onto the GRD. Source is
flat file from ifeed servers; data is loaded on db2 databases using LTMS
(load tracking management system) informatica and autosys.
Responsibilities:
. Involved in requirements gathering.
. Design Informatica mappings and workflow for projects and PL/SQL stored
procedures.
. Provided QA support and bug fixes.
. Worked on install script for database objects, shell scripts, informatica
and autosys.
Environment: Informatica, Oracle, Shell Script, Autosys
Company: R.C.Technical Institute, Gujarat India
Jun 2001 - Dec 2004
Title: Lecturer/Developer
R.C.Technical Institute is a Government Engineering- Diploma college. The
institute will be leader in imparting qualitative competency based demand
driven technology and engineering programs.
Responsibilities:
. Hands on lab and project experience for Database SQL and PL/SQL,
Programming C, C++ and Java.
. Implementing University research projects
. Actively leading class discussions and encouraging debate.
. Responsible for preparing learning material for courses and devising
relevant practical activities.
REFERENCES:
Furnished upon request.
Contact this candidate