JHARNA JAIN

****, ****** ***** ** ***-C Atlanta, GA 30067 660-***-**** acxfn6@r.postjobfree.com

Available for full-time BI Developer (Location Flexible)

SUMMARY

Involved in Requirement gathering & designing QlikView Applications.

Creating and Managing QlikView Reports & Dashboards.

Designing Data Modeling and Loading data from Multiple Datasources.

Experience in complete project life cycle including documentation, analysis, and development and testing.

Worked with Business Analyst and the Business user to understand the user requirements, layout, and look and feel of the application to be developed.

Expert in Business Intelligence Applications using Cognos Tools such asCognos10.1/8.

Extensive knowledge with Dimensional data modeling star schema, snow flake schema, Fact and dimensional tables.

Good verbal and written communication skills, analytical skill and competent team player.

Documented and analyzed user requirements.

Review client requirements and translate to technical solutions for development.

Diagnosed and addressed operational data requests.

Gathered and analyzed business end user data and identified solutions strategies for report requirements.

Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).

An excellent team player & technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

Knowledge and work experience in RDBMS concepts, Views, Triggers, Stored Procedures, Indexes, and Constraints.

Excellent hands on experience in handling the defects throughout the bug life cycle from detection until resolved using JIRA.

Expertise in Black box testing, Functional testing, Integration testing, Database testing and Regression testing.

Proficiency in developing SQL with various relational databases like Oracle, SQL Server.

Knowledge in Full Life Cycle development of Data Warehousing.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

TECHNICAL SKILLS

Languages : Java, C, C++, HTML, Java Script, CSS, XML

ETL Tools : Informatica Power Center 9.6.1/9.6.0, 9.1, 8, 7

Database : MS SQL server 2005/2008/2012/2014 Oracle 11g.

Methodologies : ETL, OLAP, Agile Scrum, Software Development Life Cycle (SDLC)

Office Tools : MS Office suit (Word Excel, Power Point, Access)

Tools : HP Quality Center 12, Toad, Cognos10, QLIK, Tableau, Oracle SQL Developer, JIRA.

EXPERIENCE

Genuine Parts Company July 2015 – Present

BI Developer

Involved in daily batch loads (Full & increment) into staging and ODS areas, troubleshooting process.

Performed business analysis and wrote SQL scripts to analyze data and parse to excel.

Collect data, develop complex queries and perform data modeling.

Experience of data warehouse concept, OLAP and OLTP. Technologies such as ETL process,

Dimensional modeling, star and snowflake schemas, populating and maintaining Data Marts.

Created new ETL packages with new package configurations, look ups of new business logics.

Create basic and advanced reports, dashboards, and KPI scorecards using Microsoft BI stack (Power BI, SSRS).

Used SSIS to create ETL package to validate, Extract, Transform and load data to data.

Create SSIS Package with which data from different resource were loaded daily in order to create and maintain a centralized data warehouse.

Loaded data from different data sources (for example: excel, flat files, SQL) to SQL server data base.

Used Power BI tools (COGNOS & QLIK) to develop interactive reports to update on Dashboard.

Knowledgeable on SDLC methodologies, especially agile scrum and waterfall, at the system

Analysis, design, development and implementation stages.

Flexible to work with any new environment, with a strong interest in learning new technologies.

Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

WebLogic, IT Solution and Development, Indore, India January 2013 – April 2014

ETL Trainee

Conduct mathematical, statistical, and other analyses of the data as appropriate.

Analyze and develop the new objects in Test environment and after testing the objects and

Reports, migrated to Production Environment.

Involved in gathering and understanding business requirements and implementing those in the workflow.

Used ETL tools to implement slowly changing dimensional maintain Historical data in data warehouse

Capable of using data from SQL server, ORACLE, Excel, CSV files and FLAT files.

Analyzed financial and operational data requirements to support managerial problem-solving, planning, and decision-making.

Involved in creating dash-board report based on business requirement using report builder.

ACADEMIC PROJECTS

E-Commerce Online Library Management System Spring 2015

Data capture and data loading from disparate sources.

Created reports to show various key metrics.

Integration of front end application with the dashboard and reports.

Allocated multiple user roles and assigned privileges to each user group to access user specific data.

Online Driving Test Spring 2015

Developed Responsive UI using HTML, CSS, JavaScript, jQuery.

Designed and consolidated functionalities such as User Login, Authentication, Supply Logistics, Inventory Management and Financial Management.

Created a Database for driving test to store answers of the Questions by using SQL server.

EDUCATION

University of Central Missouri, Missouri December 2015

Masters of Science in Information Technology

RGPV, India May 2014

Bachelor of Engineering in Computer Science

Contact this candidate