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 client 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 learning 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, Informix, MySQL, Teradata
• ETL Informatica, SSIS, PL/SQL, T-SQL, UNIX Shell scripting
• BI Reporting Tools Cognos, Business Objects, SSRS, SSAS, Tableau, 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, MS Visual Source Safe, Git, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

• 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.
• Migrated Cognos 8 packages, Cubes, Reports and Dashboards to Cognos 10. This migration helped in
• fine tuning existing packages, cubes and reports with better performance and usability
• Created several SSIS ETL packages to migrate current and historic data to Peet's Data Warehouse
• Optimized ETL packages, database objects and data load design for better performance
• Worked on setting up ESRI component to integrate Peet's Data Warehouse data to display pictorial
• form in Cognos Reports and Dashboards, and integrating with location demographics which helped
• the business to analyze the data for better decision support
• Provided Cognos Training to Business Users and supported with new ideas for Business Analytics
• Maintained and monitored production support activities and monitored ETL and Cognos cube build jobs

Confidential

Sr Consultant Data Warehouse Business Intelligence

• Worked on 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, Business 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
• Negotiated and maintained relation with vendors proposing cost effective license packages
• 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 are reusable scripts which are used for every major and production
• support releases which helped testing duration from few days of work to few hours.
• Managed and lead team of 4 offshore resources and delegated tasks accordingly in timely manner
• 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
• Utilized Cognos and SSRS as Reporting tools creating Reports, Metrics and Cubes

,

Confidential

Sr. Informatica Developer

• Performed source analysis, created PRICING tables and prepared documents for related codes
• Created detailed technical requirements from Functional Requirement Specification FRS
• documentation to System Requirement Specification SRS documentation.
• Created and migrated Informatica mappings and workflows from RMS/RPM
• Created 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

Confidential

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

Confidential

Developer/Trainee

• Undergone training on Oracle PL/SQL, Informatica, Java, Mainframes and other related technologies
• Developed Informatica ETL mappings and PL/SQL packages for a project assigned to the team based
• on given design and business requirements