Post Job Free

Resume

Sign in

Sql Server Project

Location:
Kirkland, WA
Posted:
November 11, 2016

Contact this candidate

Resume:

BHARGAVI RENGARAJAN

acxgjb@r.postjobfree.com, ***** 102nd Ave NE, Kirkland WA, 98034. Mobile: 425-***-****

SUMMARY

•7+ years of industry experience with Masters in Business Administration.

•Contributes to program management by actively participating in the overall project’s development and continuous improvement of processes, procedures and tools.

•Strong experience in cross-functional communication and decision making, ensuring alignment with internal and external stakeholders.

•Take strong ownership for accomplishing requests, explores various opportunities to add value and can multi-task if need be.

•Collaborates well with peers & management on plans and reviews, seeks and provides feedback as required to complete action items in a timely fashion.

PROFESSIONAL EXPERIENCE

Content Management: Client: Microsoft, WA Nov 14 – Till date

•Conduct meetings with stakeholders to analyze and document project requirements.

•Publish Newsletters and campaigns for Learning Experience group using Exact Target.

•Launch sites in Infopedia 3.0 using Infopedia Publisher Dashboard.

•Migration of Bing 2.5 to 3.0

•Conduct documentation reviews “walkthroughs” with project team and support training efforts.

•Coordinate upgrades & new functionality with internal and external technology teams using SharePoint.

•Communicate and collaborate with developers, designers, and business owners in all stages of the project lifecycle.

•Design and document customized analytics tracking specifications for digital content and partner with development teams from Development to UAT and implementation.

•Provide in-depth custom analytics reports to communicate key metrics, findings, and recommendations.

•Identify trends and issues about site usage, drivers to site and visitor loyalty.

Campaign Reporting Interface (CRI): Client: Washington Mutual, WA Oct08-Mar09

•Configuring & managing SQL Server 2005/2008 for SQL, SSAS, SSIS, and SSRS.

•Developing reports on SSRS on SQL Server (2005/2008). Experience in writing expressions in SSRS and fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.

•Creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Mortgages: Client: Unisys Financial services, Chennai India May 07-Aug 07

•Gathered Requirements, Developed & maintained Summary, Drill down Reports, Scorecards for business customer’s requirements SQL Server 2005

•Consolidate & deliver new reports/analysis per business requirements and drive business results/decisions.

•Code the changes via LINC software and T-SQL/Stored Procedure changes on SQL Server for reporting needs.

•Prepare and Plan for testing via Test Cases and reviews. Perform data testing, black box testing, White box testing, Unit Testing & peer reviews

•Co-ordinate with onsite and get feedback on User acceptance testing & loop through the life cycle to fix bugs.

Cyborg Team – US Payroll: Client: Mervyns Chennai, India Feb 07-Apr 07

•Gather Business Requirements for enhancement requests. (BRD) for Payroll domain.

•Developed Payroll system using SAS, DB2, JCL, Cyborg Scripting language, assembly language (Report generator)

•Functional Specifications documentation and design documentation

•Perform codes changes via JCL, RM-COBOL, Database2(DB2)

•Prepare Test cases plans and co-ordinate with QA team members.

Prevention of Money Laundering (PML), NEFT: Client: Corporation Bank Chennai, India Feb 06 - Jan 07

•Review the business specification document and clarify the details based on the customer specifications provided. (BRD)

•Create the functional and design documentation based on the requirements provided and training.

•Employ RM COBOL coding techniques to formulate/build new program / enhance the existing program.

•Added value to the team by sharing domain expertise during course of the project.

•Used domain knowledge on Prevention of Money Laundering (PML) to achieve the desired functional results.

Foreign Remittance: Client: ABN AMRO Central Enterprise Services Private ltd Chennai, India Oct02 – Jan06

•Electronic Fund Transfer), RTGS (Real Time Gross Settlement), ECS (Electronic Online money transactions for the bank end customers using International banking systems such as SWIFT, INTELLIMATCH & corporate customer software like SCORE.

•Tracking various queries lodged by customers and periodic review of status of the payments using INTELLITRACK tool.

•Day to Day Interaction with end customers scrutinizing their documents and ensure that they are under the purview of FEMA (Foreign Exchange Management Act), FERA (Foreign Exchange Regulation Act) & RBI (Reserve Bank of India) guidelines.

•Processing payment in compliance with OFAC (Office of Foreign asset control) & EU (European Union) sanctions.

•Processing of domestic & International payments via electronic fund transfer channels using NEFT (National Clearing Service), STP (Straight Through Processing)

GOMC Challenge Jan 16 – Mar 16

•Participated in 2016 - Google Online Marketing Challenge (GOMC) for West Seattle Art Nest on creating AdWords online marketing campaign for creating brand awareness and improved sale of their products.

CERTIFICATION

•Bing Ads Accredited Professional status Oct 20, 2016

•Google AdWords certified

(Valid August 2016 – August 2017) Aug 7, 2016

•Google Analytics certified

(Valid August 2016 – February 2018) Aug 7, 2016

•Microsoft Certified IT Professional - Business Intelligence Developer Sep 20, 2008

•Introduction to Oracle 9i - SQL Sep 13, 2008

•Microsoft® SQL Server™ 2005 Business Intelligence Development Aug 23, 2008

•Microsoft Certified IT Professional - Database Developer Aug 09, 2008

EDUCATION

•Technology MBA from University of Washington GPA 3.72 (2014-2016)

•Masters in Software Information System 87.5% (2002-2004)

•Bachelor’s degree in Chemical Engineering 87.5% (1998-2002)



Contact this candidate