Namrata - MS SQL Server
Published on: Mar 3, 2016
Transcripts - Namrata - MS SQL Server
Page 1 of 4
Skillful - dynamic IT professional, having 7 years of extensive experience in SQL server in Designing,
Development and operational application/production support.
Involved in decision making ofprojects for Design, Development, Testing and deployment along with application
ITIL Foundation Certified.
Experience in designing, data modeling and Developing BI Data Warehousing projects.
Experience in T-SQL, DTS, SSIS, SSRS development.
Experience in SQL Server Performance tuning and good knowledge in Administration.
Experience in migration of SQL servers.
Experience of working in Agile – SCRUM.
Have good experience in leading and supporting BAU’s and DW projects.
Leading and Managing Production SupportTeam and Streamlining the Process.
Strong troubleshooting and performance tuning experience in SQL servers and ETL.
Good Knowledge of C#, Oracle, ODI, MySQL, SAP BO, Erwin, TFS.
Technical Skills :
T-SQL, Microsoft SQL Server (MSFT Database Development),Database Designing and Data
Modeling , MSBI (SSIS/SSRS), Data Warehouse [Designing ,Implementation and Support],
Operating Systems: Windows
Lanuages: .NET Programming(C#,ADO, VB.Net), VBScript, SQL,
PL/SQL, WPF, LINQ, ASP, HTML, XML, OQL, C, R
Databases: SQL Server, Oracle, MySQL
ETL Tools: SSIS,ODI,TALEND
Reporting Tools: SSRS, SAP BO
Data Modeling Tools: MS Visio, Erwin.
Version Control Tool: TFS, SVN
ITSM tool: Assyst, HP Quality Center,JIRA
Functional (Domain) Skills:
Banking and Finance:
InvestmentBanking : Clearing and Settlement,Equities,Dividends,
CREST, Cash & Equity Reconciliation.
Insurance : Portfolio Management
Accounting : Oracle R12,COA
• Good knowledge on Billing, bank accountreconciliation and generation ofreports.
• Excellent communication and Clientinteraction and good Leadership quality.
• Good knowledge ofApplication Outsourcing (maintenance) life cycle and process.
• Have a good understanding ofSDLC and projectlife cycle.
• Understanding ofITIL process and RACI charts/reports.
• Excellent analytical and problem solving skills.
Page 2 of 4
Certificates and Awards:
Top performer of the Year 2013 – From Iron Mountain Services Pvt. Ltd, India
Application Outsourcing (AO) proficientcertificate from Accenture.
Level I certification in Capital Markets
Providing Technical training to professional on MS SQL SERVER, T-SQL.
Current Employment Details:
Currently I am working as an individual contributor and handling multiple data warehousing projects in BIplatform
in differenttechnologies like – SQL server, Oracle and My SQL. Below is listof projects with key role, duration and
CURRENT EMPLOYEMENT DETAILS: Duration: Since Jan 2013 to till date
BI Projects Details
BI Project Name #1 Billing Data Mart (BDM)
Duration Jan 2013 to till date
SQL Server, SSIS, Business Objects(BO) Reports,Oracle 11g,
Key Role and Responsibilities Application/Production Supportand Enhancements
BI Project Name #2 AURORA
AURORA - New Billing Data warehouse to facilitate the
accounting and provide business to pull reports.
This system is developed to align with Oracle R12 - Chart of
Accounts for accounting all organizational
Duration Sep 2013 to till date
Business Objects(BO) Reports, SQL Server 2012, SSIS,JIRA,
Assyst, SAP BO 4.0, ODI 11g
Key Role and Responsibilities
Requirementgathering,Designing, data modeling,Development,
UAT, Go Live support, Production Support, Documentation
BI Project Name #3
REIT ( Real Estate Investment Trust) – Database designing ,
Duration April 2013 to Aug 2013
Platform/Technologies/Tools Used Business Objects(BO) Reports, SQL Server 2008 R2, SSIS
Key Role and Responsibilities Database designing,data Modeling,Development.
BI Project Name #4 Duns and Bradstreet (D&B)
Duration Oct 2013 to Dec 2015
Platform/Technologies/Tools Used Business Objects(BO) Reports,Oracle 11g, ODI
Key Role and Responsibilities Developmentand Application Support
Page 3 of 4
BI Project Name #5 Customer Data Mart(CDM)
Duration Apr 2014 to June 2015
Platform/Technologies/Tools Used MySQL, SOAP, TALEND
Key Role and Responsibilities Operational/production support
BI Project Name #6 Revenue Management(RM)
Duration Sep 2014 to till date
Platform/Technologies/Tools Used SQL Server 2008 R2, SSIS, DW
Key Role and Responsibilities DW,Operational/Application Support
BI Project Name # 7 SKP (Safe keeper Plus)
Duration July 2015 to till date
Platform/Technologies/Tools Used SQL Server 2012,SSIS
Key Role and Responsibilities Operational DB Support
• You ROCK’ Award for – Excellent Job on being Action Oriented
• Appreciation on - On Excellent Multi Tasker awardfor Excellent Job on being Action Oriented
from Christo Mekkattukulam (GM and Vice President, Iron Mountain India Head, Bangalore)
• ‘You ROCK’ Award for – On Excellent Job on being Action Oriented
From Ananth Swamy(Senior Manager, Enterprise Information Solutions, Iron Mountain, Boston)
• ‘YOU ROCK’ Award for - Excellent Job on Total Customer Satisfaction
From Kayhan (Technical Manager, Delivery IT, Iron Mountain, Boston)
• Employee of The Year 2013 Award.
• Travelled to Boston, MA, USA to bring the Production support activities (L2 and L3) to India
Team from US for AURORA Project. Was actively involved in making sure all transitioning activities are
covered for the team in order to support the product since Go Live.
PREVIOUS EMPLOYEMENT DETAILS: Duration:May 2008 to Nov 2011
Company: ACCENTURE JobProfile:Software Engineer
Project Name #1 Equiniti
Duration Aug 2008 to July 2011
C# .Net 2.0/3.0/3.5, SQL Server 2005/2008 R2, Visual Studio
2005/2008/2010,SSRS,SSIS, MS Excel, TFS.
Key Role and Responsibilities
Developmentand Production Supportwith SQL Administration,
DB migration From 2005 to 2008 R2.
Project Name #2 KPN
Aug 2011 to Nov 2011
Page 4 of 4
Platform/Tools/Technologies C# .Net 3.0, WPF, CCF Framework,SQL Server 2008 R2
Key Role and Responsibilities Database Designing and Development.
PREVIOUS EMPLOYEMENT DETAILS: Duration:Sep2012 to Dec 2012
Company: Wolters Kluwer JobProfile:DBA Developer
Project Name Equiniti
Duration Sep 2012 to Dec 2012
Platform/Tools/Technologies VS2010, SQL Server 2012, SSIS, BI, DW, MS Excel
Key Role and Responsibilities Production Support , DB Performance Tuning and Job monitoring
B-Tech (Electronics & Telecommunication) from PIET, Rourkela, Orissa, in 2007. Gold Medalist.
10+2 from KendriyaVidyalaya, Rourkela , CBSE Board in 2003.
from KendriyaVidyalaya, Rourkela, CBSE Board in 2001.
CONTACT ADDRESS : #514, 5th
DOB : 11th
VISA : B1 (USA) VISA valid till Feb 2024.