Post Job Free

Resume

Sign in

DWH-BI

Location:
Richmond, VA
Posted:
January 06, 2017

Contact this candidate

Resume:

VINOTH RAMACHANDRAN acx2g7@r.postjobfree.com

612-***-****

PROFILE

Around 9 years experienced, passionate BI/DWH data professional that thrives on exploiting data to present the critical information that drives the business. Solution-driven professional with deep subject matter knowledge in architecture; including identifying, designing, implementing, managing and delivering large and complex enterprise-grade business solutions. Skilled in identifying and directing technological development initiatives, selecting technologies, and applying development methodologies aimed at directly supporting and enhancing core organizational roadmaps.

TECHNICAL COMPETENCIES

PROFESSIONAL EXPERIENCE

Sr.Technical Lead 2014 – Present

Wipro Ltd Target Corporation, MN

Led & mentored team for implementing a DWH project to create business intelligence in support of healthcare services

Summarized and presented strategic insights to a diverse audience of key decision makers including senior management.

Worked on POC by looking for implementing new technologies and regularly looked for business improvements by implementing data quality monitors using SAS/SSRS/Tableau & data reconciliation processes

Proposed & implemented a solution on Big Data-Hadoop for inventory tracking system, which helped organization to analyze the sales

& maintain the inventory during offers

Worked on requirements gathering & prepared the project solution/architecting and effort estimation

Analyzed data to translate the business requirement to data model using ERWIN, source to target mapping & design

Developed error handling & statistics management for new and old system

Remodeled existing system to a faster, cleaner enterprise DW by reverse engineering

Developed ETL/ELT packages/jobs to support business for taking actionable measures and visual insights to improve prescriptions ready when promised, fill times & dispensing rejections, resulting in 12% increase in number of satisfied guests

Creating various types of reports & metrics to support Healthcare statistics/metrics & omnichannel fulfillment capabilities. Lead ETL Developer/Technical Lead 2012 – 2014

Wipro Ltd Target Corporation, MN

Implemented a data integration solution complementing a major pharmacy initiative in enabling critical compliance and guest facing reporting functions supporting end users

Delivered interim reporting solutions to support the roll-out of the new dispensing application

Implemented compliance reporting solutions to ensure compliance with regulatory laws

Developed templates and checklists for review and testing

Help building standards and guidelines including object naming conversion & definitions

Developed framework to migrate data & to build ODS

Developed SSIS packages, Teradata-BTEQ scripts for data integration, reports using SSRS such as complex drill down & drill through reports, cascading parameters report, sub reports and charts using MS-SSRS 2012, 2008 & SQL Domain Retail, Healthcare & Pharmacy

Databases SQL Server 2008/2012, Oracle 9i/11g, TeradataV14, IBM DB2 UDB, Hadoop, MS Access Data Modelling Tools ERWIN, MS Visio

ETL Tools SQL Server Integration Services-SSIS

Programming Languages SQL, T-SQL, PL/SQL, BTEQ, Unix Shell Script, Hive Reporting Tools SQL Server Reporting Services-SSRS, Tableau Scheduling Tools Control - M, Crontab, Oozie

Analytical/Viz Tools SAS, Tableau

SDLC & Agile Methodology Tools Waterfall, Agile, Version One, Jira Build/Code Version Management GitHub, MS-TFS

Methodologies/Tools/Technologies Mercury Quality Center, Sqoop

Performance testing of the SSIS packages post development and query tuning activities for optimization of queries

Created implementation plan and coordinated with multiple team for implementation of Reporting Mart, ODS Senior Software Engineer 2010 – 2012

Wipro Ltd Target Corporation, INDIA

Analyzed conceptualize planning, documenting and business requirements gathering.

Involved in data analysis of existing legacy systems to build new system

Development of SSIS packages, PLSQL scripts, UNIX scripts for data integration

Co-ordinate testing efforts with QA, identified, tracked issues and resolved project issues in a timely manner.

Created the detailed design document (LLD) & work flow through control-m

Involved in implementation

Software Engineer 2008 – 2010

Wipro Ltd Target Corporation, INDIA

Developed packages in SSIS, contributed in CIT phase,

Prepared Control-M flow in MS Visio diagrams & Scheduled/run the jobs in Control-M

Created test cases, scenarios and involved in CIT, ST testing

Production support, monitor and troubleshoot during the daily load activity EDUCATION

SRM University – Chennai, TamilNadu, INDIA

Bachelor of Technology in Mechanical Engineering



Contact this candidate