SUMMARY:

• Experienced Business Intelligence & ETL Developer in various business domains with 6 years of overall experience in Software development, testing and web based applications. Experience in collaborating with multiple teams and delivery in fast phased, highly visible and value add implementations. Results driven, enthusiastic and fast learner individual looking for new opportunity.
• BI consultant with proven experience in multiple implementations using multiple domains
• Hands - on experience with several BI tools, Reporting tools and Analytic tools like Business Objects, Tableau, QlikView & Qlik Sense
• Certified QlikView Designer and Qlik Sense Business Analyst
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling, and reporting tools
• Understating of Metadata management, Master data Management, Data Quality, Data Security, Data Governance & Data Stewardship
• Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data
• Experienced in writing and designing the SQL queries
• Experienced in all stages of software development life cycle
• Experienced in Customer Master Data implementation with direct interaction with customers
• Knowledge in .Net Framework, ASP.Net, and C#
• Experienced in XML, CSS, HTML, IIS and JavaScript
• Self-motivated, fast learner and team player with interpersonal skills
• Excellent verbal and written communication
• Ability to work in tight schedules and on multiple applications simultaneously

TECHNICAL SKILLS:

BI / DWH Tools: SAP Business Object, Crystal Reports, Tableau, QlikView, Qlik Sense, Informatica Power Center, SSRS

Data base: SQL Server, MS-Access, Oracle

Development Tools: SQL, C#, .Net, ASP.Net, HTML, XML, ASP, and JavaScript, JAVA

Tools: /ERP: Visual Studio, QTP, Test Director and SAP (basic knowledge)

Operating Systems: UNIX, Windows XP/2000

PROFESSIONAL EXPERIENCE:

Confidential

BI Report Developer

Responsibilities:

• Developed Circulation, Acquisition and Patron Details reports using Business Objects functionalities like Drill down, Cross tab, LOVs and Formulae
• Created financial report such as Daily payments and Billing Summary report
• Developed and tested reports using Business Objects Web Intelligence 4.1 SP5
• Created Web Intelligence reports with tables, charts, images, and hyperlinks from a relational universe
• Created input controls to dynamically filter data in the report and created variables to capture selections in the input control
• Created standard reports utilizing features of Web Intelligence like optional prompts, Functions, and Alerts etc.
• Created breaks and filters at different levels of the reports and applied ranking in the Webi reports

Confidential

ETL Developer

Responsibilities:

• Participated in requirement gathering meetings with business analysts to understand Source Data, Technical Metadata
• Documented required technical metadata such as source and target definitions
• Created mapping documents to outline data flow from sources to targets.
• Extracted data from XML, flat files and oracle databases and loaded it into Hbase database
• Developed programs for an extraction and parsing prep data for loading

Confidential

Responsibilities:

• Gathered Requirements for Prototyping for Confidential North American Reporting System
• Analyzed 31 current state crystal reports and related stored procedures
• Analyzed current North American Reporting System universe
• Developed 2 functioning prototypes in Business Objects Web Intelligence and QlikView

Confidential

Report Tester

Responsibilities:

• Tested several dashboards and signboards developed in SAP Xcelsius and SAP Business Objects
• Written test cases to test the entire application manually
• Coordinated with the developers regarding the defects raised and retested them against the application.
• Tracking and analyzing the defects and recording the variation between the expected and actual results
• Prepared extensive set of validation test cases to verify the data.

Confidential

Informatica Developer

Responsibilities:

• Developed standard interface Source to Target Mappings (STTM) and elicit transformation rules for ten new extracts
• Developed ETL design and technical specifications
• Using Informatica as an ETL tool to extract data from source systems and load into an SQL Server Database
• Used Information Analyzer and SQL skills for Column Analysis, Primary Key Analysis, and Foreign Key Analysis
• Developed test case documents. Worked with QA teams in a support role answering questions and walking through the jobs.

Confidential

Customer Data Analyst

Responsibilities:

• Accountable for delivering multiple Customer implementations
• Customer Data Analysis - Assisted with analysis of customer data for classification and leveraged 3rd party data to support analysis
• Responsible for ensuring high data quality and accuracy of customer data through analysis using multiple data sources like SDI, Dun and Bradstreet, and internet based research as well as with an understanding of the business need
• Maintained Customer Master Data leveraging multiple technologies with good understanding on technologies (SAP Portal forms, SAP ECC, IBM MDM and share point)
• Responsible for User Acceptance Testing for Customer Master Data for SAP Portal, ECC and IBM MDM Solution components
• Provided requirements for Master Data reports to improve Business operational efficiency. Consumed these reports on a daily basis to run the day-to-day operations
• Assisted in the data classification projects. Researched accounts online and SDI data sources to classify them according to IDN structure
• MDM Responsibilities include: source account research, account aggregation and mapping analysis of all daily new accounts created by business unit source systems, and integration of accounts used for a multitude of enterprise and business unit level consuming systems
• Evaluate candidate files for integration or elimination into the prospective customer or Cardinal Business Unit file(s)
• Processed on average one thousand records per week at an accuracy rate of 98%
• Received multiple recognitions and awards including fast learner award

Confidential

Developer

Responsibilities:

• Responsible for requirement analysis, design, and development of corporate website
• Developed the complete web site including dynamic product list along with images, enable paging, sorting using C#
• Developed administrator User interface for ease of maintenance of new products and o upkeep the web site with minimal IT intervention
• Responsible for testing the end-to-end solution
• Used web mail in contact us page

Environment: ASP.Net, C#, HTML, XML. Adobe Photo shop, Some Flash.

Confidential

Programmer

Responsibilities:

• Involved in development of ISP webpage and customization of Netscape email server for clients to create accounts and providing access to their emails.
• Design and developed over 50 websites for institutions, small scale industries and companies.

Environment: ASP, VB, Java & VB Script, MS SQL HTML, DHTML, Java Script, CGI Scripting, FrontPage, Dreamweaver, UNIX, Windows NT.