SUMMARY

• Overall 9 years 5 months of experience in Database Design & Development, Data Modelling and Performance tuning in Database technologies like Sybase, MSSQL Server, MongoDB and Neo4j(Graph Database).
• Experience in MongoDB architecture, Performance and Indexing, Aggregation framework, Configuring Replica Set, Sharding.
• Data Modelling (Conceptual/Logical/Physical) for OLTP and dimensional databases(OLAP), data warehouse architecture, data Integration, data profiling
• Data analysis, Database programming (Stored procedures; Triggers, Views), Table Partitioning, performance tuning
• Strong noledge of Non - relational(NoSQL) databases viz.Document,Coulumn, Key-Value and Graph databases
• Neo4j architecture, Cipher Query Language, Graph Data modelling, Indexing.
• Trained in all the Anti money laundering Actimize components of Analytics Intelligence Server (AIS) and Risk Case Management (RCM), ERCM and Plug-in Development.
• Very good experience in UNIX shells scripting.
• Strong Experience in Business Analysis, Data science and data analysis.
• Strong noledge of SDLC (viz. Waterfall, Agile, Scrum) and PMLC.
• Strong Knowledge of BFS Domain including Equities, Fixed Income, Benchmarking etc.

TECHNICAL SKILLS

Programming Languages: T-SQL, C/C++, Python, Perl, Core Java, Java Script, Unix Shell Scripting

Databases: MSSQL Server 2005, Sybase 12.5 and 15.0,MongoDB,Neo4j

Cloud Computing: Amazon Web Services

XML Technologies: XML, JSON

Version Control Systems: VSS, Clearcase, CVS, SVN

Design Tools: MS Visio, Erwin

ETL: Informatica

PROFESSIONAL EXPERIENCE

Confidential, NY

Data Architect

Responsibilities:

• Analysing and documenting the existing CMDB database schema.
• Designing application driven architecture to establish the data models to be used in MongoDB database.
• Data modelling activities for document database and collection design using Visio.
• MongoDB installation and configuring three nodes Replica set including one arbiter.
• Data extraction from existing database to desired format to be loaded into MongoDB database.
• Assisting in web design to access the data via web browser using Python, Pymongo and Bottle framework.

Confidential, NY

Sr. Database Consultant

Responsibilities:

• Stored procedures development in Sybase 15.0 related to regulatory changes.
• Enhance the system documentation.
• Unix Shell scripting to automate the manual works viz. reports validation, job re-runs.
• Resolve open issues and concerns as discussed and defined by BNYM management
• Analyse, design, code, unit/system testing, support UAT, implementation and release management.
• L3 support for the application.

Confidential, MN

Technology Lead

Responsibilities:

• Analysing the current data flow of the 8 Key Marketing Dashboards.
• Analysing the input data stream and mapping it wif the desired output data stream.
• High level data design including the database size, data growth, data backup strategy, data security etc.
• Establishing the frequency of data, data granularity, data loading strategy i.e. Delta load, full load.
• Ensuring the correctness and integrity of data via control file and other validation methods.
• Data warehouse experience in Star Schema, Snowflake Schema, Slowly Changing Dimensions (SCD) techniques etc.
• Co-ordinating the design and development activities wif various interfaces like Business users, DBA’s etc. for the project.
• Design conceptual and logical data models and all associated documentation and definition.
• Produce and/or review the data mapping documents.
• Designing the database reporting for the next phase of the project.

Confidential

Data Architect

Responsibilities:

• Dataflow design for new feeds from Upstream.
• Data warehouse design and development.
• Using SQL Server profiler to diagnose the slow running queries.
• Tuning the slow running stored procedures using TEMPeffective indexes and logic.
• Writing stored procedures in SQL server to implement the business logic.
• Root cause analysis for any issues and Incidents in the application.
• Documenting guidelines for new table design and queries.
• Change Coordinator role for End-to-End delivery i.e. taking requirements from clients for any change, providing initial timelines, analysis of change and its impact, passing on the change to the respective module developer and following up for completion, tracking the change in system, testing the change in UAT, deploying the change in prod env, post deployment checks and support for the deployed changes.

Confidential

Sr. Database developer

Responsibilities:

• Data modelling activities for new enhancements, writing stored procedure to include various regulations.
• Involved in estimation, analysis, design and development of all the GTW components involving Sybase and Unix scripting.
• Debugging the stored procedures and shell scripts to find any data discrepancy or any unusual behaviour of the application.
• Testing and release management of any new changes.
• Project maintenance and 3rd Level Support activities, involving direct interaction wif the client.
• Issue or bug prioritization, tracking using JIRA web tool.
• Mentoring of new team members

Confidential

Sr. Database Developer

Responsibilities:

• Worked independently as a solution provider in the Sybase server up gradation from version 12.5 to 15.5 for Confidential (US) Fixed Income Group.
• Code changes in the Sybase stored procedures.
• Developing the testing strategy to test the changes made in the stored procedures.
• Deployment of changes in UAT and ensuring the UAT approvals.
• Liaising wif the DBA’s to ensure the smooth database up gradation from 12.5 to 15.0

Confidential

Database Developer

Responsibilities:

• Impact Analysis of any Business Logic Change.
• Writing Stored Procedures Triggers, Performance Tuning etc.
• Completing the whole life cycle of the project which encompasses requirement gathering, preparing MDD, development, Unit testing & Integration testing in UA environment, release preparation plans and finally production rollout.
• Sybase Migration from 12.5 to 15.
• Onsite Co-ordination, Bug Fixes, Metrics & Schedule estimation in the project (which includes productivity, defect density).

Confidential

Developer

Responsibilities:

• Supports B.S initiated Service flow Creation, Deletion and Change.
• Supports Classifier and PHS rules as specified in IEEE 802.16e Standards.