EXECUTIVE SUMMARY

Meticulous Data Warehouse Business Intelligence Specialist, who undertakes complex assignments, meets tight deadlines and delivers products with superior quality. Revamps existing systems by proposing efficient and cost effective solutions. Listens closely to the clients, paying attention to details and provides solutions with options. Have 10 years of experience in Data Analysis, Design, Data Modeling, Development, and Testing in Data Warehousing and Analytics. Enthusiast in Big Data, Hadoop and Data Science related technologies. Highly determined and motivated team player with outstanding written, oral, analytical and Interpersonal skills.

TECHNICAL AND FUNCTIONAL SKILLS

• Databases Oracle, MS SQL Server, DB2, MySQL, Teradata, NoSQL, Mongo DB
• ETL Informatica, SSIS, PL/SQL, T-SQL, UNIX Shell scripting
• BI Reporting Tools Cognos, Tableau, Business Objects, SSRS, SSAS, Qlikview
• Data Modeling Erwin, MS Visio
• Programming C, C , Java, HTML, XML, Java script, R
• Scheduling Tools Autosys, Control M, Batch scripting, Task Manager
• Project Management Microsoft Project, FogBugz, JIRA
• Business Analysis IBM Rational Rose Requisite Pro, CaliberRM, Confluence
• Configuration Management Perforce, Documentum, Visual Source Safe, Git, SharePoint, Confluence

PROFESSIONAL EXPERIENCE

Confidential

Sr Business Intelligence Engineer

• Closely worked with Sales, Finance, Accounting, Marketing, and Retail teams in gathering business
• requirements designed and delivered the end products that best fit for the business.
• Designed and optimized the SSIS architecture by diminishing existing Facts and dimensions by 30
• Re-designed developed and migrated Cognos 8 packages, Cubes, Reports and Dashboards to
• Cognos 10 a faster and optimized environment
• Delivered several SSIS ETL packages to migrate current and historic data to Peet's Data Warehouse
• Fine-tuned ETL packages, database objects and data load design for better performance
• Trained Business Users on Cognos tools and supported with new ideas for Business Analytics
• Maintained and monitored production support activities and monitored ETL and Cognos cube build

Confidential

Sr Consultant Data Warehouse Business Intelligence

• Assembled and delivered multiple projects in Quality Systems, Abbott Vascular Data Warehouse,
• Enterprise Application Interface, Supply Chain and Manufacturing IT teams
• Played versatile roles as ETL and Reporting Developer, Data Analyst, Quality Test Lead and
• Process Compliance Analyst PCA for various Business Intelligence and Data Warehouse projects
• Facilitated meetings and assisted in the integration efforts for merging BI platforms of various
• applications with enterprise data warehouse as data marts
• Used Informatica, SSIS and PL/SQL ETL technologies to create mappings, workflows and dtsx
• packages from various source systems to target Abbott Vascular Data Warehouse system
• Slashed payroll/benefits administration costs by 30 by negotiating pricing and fees with vendors
• proposing cost effective license packages
• Created Informatica maps using various transformations like SAP BAPI/RFC, SAP IDOCs, Web
• services consumer, XML, HTTP transformation, Source Qualifier, Expression, Look up, Stored
• procedure, Aggregate, Update Strategy, Joiner, Union, Filter and Router
• Performed ALM tools assessment and selected tools which best fit for the organization and involved in
• process design based on the Audit findings and setup of the ALM tools. This helped to stream line the
• IT projects process flow that helped for Audit purposes.
• Reviewed Cognos 7 and 8 Reports, cubes, servers and licenses and disabled unnecessary licenses,
• this saved the company in total licensing costs per year.
• Designed and developed unit testing for ETL packages using Unix shell scripting to reduce the
• regression test timelines. These reusable scripts are used for every major and production
• support releases which helped testing duration from few days of work to few hours.
• Played critical role in installing and administering Tableau Server and configuration and managed
• delivering several workbooks, dashboards and packages using Tableau
• Utilized Cognos, SSRS and Tableau Reporting tools creating Reports, Metrics and Cubes
• Circuit City, Richmond VA Client Sep '06 May' 07
• Data warehouse Informatica Developer
• Performed source analysis, created PRICING tables and prepared documents for related codes
• Delivered detailed technical requirements from Functional Requirement Specification FRS
• documentation to System Requirement Specification SRS documentation.
• Designed developed Informatica mappings, workflows, sessions, ETL jobs, Unix Shell scripts to load
• data into source or stage from RMS/RPM
• Delivered and institutionalized Star and Snow flake logical and physical design models using
• Microsoft Visio to depict the flow of the Mappings.
• Debugged data output irregularities, fine-tuned the design and code as part of quality control
• Dakota State University, Madison SD Jan '05 May '06
• Graduate Research Assistant
• Designed and built web-based feedback form project for 'Department of Social Services State of South
• Dakota in Tablet PC Training' which was undertaken by the University
• Tutoring and grading on DBMS, Oracle 9i, Data Modeling and Design concepts
• Assisted Professors in researching content for Technical papers