DWH-BI
Resume:
VINOTH RAMACHANDRAN *********@*****.***
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