SUMMARY

• Around 10 years of IT Experience in Design, Development and Analysis of BI and Data Warehousing applications.
• 6+ years of Extensive working experience with Microsoft Business Intelligence 2008R2/ 2012, Tableau 9.0/ SQL Server 2005/2008/2012.
• 4+ years of in depth knowledge of Oracle Pl/ SQL 9i/10g, Sql server 2008, Teradata
• Extensive 3+ years of experience in understanding the Business systems and writing requirements for system/application development.
• Extensive experience in designing and developing Reports for Energy and Utilities.
• Created Data Mart specific to the customers reporting purposes. Extensively worked SQL Server Reporting services and Tableau to derive the Customer metrics.
• Extensive experience in creating Dynamic Dashboards, Score Cards and KPI reports.
• Experience in creating user specific reports with Graphs in SSRS/ Tableau/BOBJ
• Used ETL methodology for supporting Data Extraction, transformations and loading processing, in a corporate - wide ETL solution, Dimensional modeling, Star schema, Snowflake modeling, Data marts, normalized data models and de-normalized data models, Waterfall Model and Agile Methodology
• Worked extensively on Oracle 8i/9i/10g/11g, MS SQL Server, Teradata and DB2.
• Analysis of Data, providing support to the application Development team with documentation on scope of data sources, existing KPI’s, scope of historical analysis and business functions.
• Experience using SSIS utilities (Data Conversion, Merge Join, Multicast, OLEDB Command, Sort, Union All etc.)
• Excellent analytical, programming, written and verbal communication skills.
• Have exposure in handling project risks and risk management along with Project management, developing estimates and implementing project plans for technical solutions.
• Sun Certified Java professional on Java Development Kit 1.6
• Have experience in validating system and Unit test cases from the Development teams and evaluate the business function.
• Have closely worked with the business users for User Acceptance testing and reporting the results as status reports

TECHNICAL SKILLS

Operating System: Windows XP, Windows 7, Unix

Languages: Java

Databases: Oracle, SQL Server, Teradata, SPARQL

Web Designing: HTML, Java Scripts

Tools: SQL Navigator, SQL Developer, Toad, SQL Server Studio, Mainframe, SSAS, SSRS, Tableau, Business Objects reports, SharePoint, Powerview

Bug Tracking Tool: Merckury, Clear case, IBM Rational

Quality Control: QC tool

ETL: SSIS, Informatica - Practitioner

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

Systems Analyst

Responsibilities:

• Working as Business Analyst/ Onsite Project Technical Lead
• Responsible for requirements gathering from the Business users and consolidate them for the development team
• Single point of contact for the Project team at onsite and has direct interaction with the Web Development, Web Admin team, Business users, SharePoint Admins and the DBA’s.
• Work on the Development of Business Intelligence ETL packages and Operational Reports
• Development of KPI reports and dashboards that helps the business to take effective decisions
• Development of Performance metrics based on different cycles of a customer
• Co-ordinate with the SME’s to understand the requirements and document the same.
• Co-ordinate with various teams involved in the project and ensuring project timelines are met
• Responsible for System integration testing and ensure the successful implementation of the requirements as expected by the Business
• Supports Quality assurance testing and User acceptance testing
• Deploy the reports into the production server
• Support deployment of deliverables and production verification
• Build Analytical layer of the project such as Complex tabular model cube
• Design the relationship for the tables and perspectives inside the cube
• Work on SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis services), Power view, PPS and PowerBI
• Work on DAX to in corporate complex logic of the reports
• Work on creating SharePoint dashboard to support the Business functionalities
• Analyze SQL server data using a tabular data model and provide the best architecture for the design.
• Ensure the system connections for the BI and Tabular model are validated
• Plan and delegate work for the developers in the team
• Ensure the functionalities of the system are implemented as per the requirements mentioned

Environment: Microsoft SQL Server studio 2008/ R2/2010/2012, Microsoft Data Tools SSDT 2014, Powerview, SharePoint 2010, Sql server 2008/2012, Oracle 10g, IBM Rational

Confidential, Houston, TX

Systems Analyst BI Developer

Responsibilities:

• Worked as Business Analyst/ Systems Analyst and ETL Team Lead at Onsite
• Have experience in understanding the specific business needs of the customer and providing business solutions accordingly.
• Have immense hands on in the implementation of Complaints, Customer Survey, Back office operations KPI processing and scorecard project executions.
• Responsible for maintaining the separate data mart for the operations team at Tulsa, Oklahoma
• Single point of contact for the MIS team who has direct interaction with the Operations team.
• Supports the operations team by providing the data and Adhoc reports according to the requirements of the Operations team at Tulsa in Tableau/ SSRS.
• Developed Decision supporting reports using Tableau.
• Point of contact for all the database related activities in the application
• Worked on creating SSIS packages for the Complaints management, Backoffice, Customer Satisfaction
• Understand and analyzes the requirements for the clients, based on which creates the suitable design for the Software development.
• Ensure the quality of data according to the Client standards and maintain data accuracy
• Maintains the version of the codes in the version control tools
• Contact various source system and ensure that the Data remains the same in the Data mart and the source system for the analytical purposes of the Operations team
• Developed PL/SQL procedures to obtain the operational and consumption metrics for the clients for the region of US North.
• Worked on the development of the Customer Survey module, creating reports for the operations team in Business Objects and integration of the same into the Data warehouse.
• Worked on scheduling, configuring and monitoring the SSIS jobs and fixing the issues in the data warehouse
• Worked on creating complex BI packages and data representation through BOBJ tools.

Environment: Microsoft SQL Server studio 2008/ R2/2010/2012, Tableau 9.0, BOBJ BI 4, Sql server 2008/2012, Oracle 10g

Confidential

Senior Oracle Developer/ BI Developer

Responsibilities:

• Worked as Database and ETL Module Lead at Offshore
• Responsible PL/SQL and SQL Server development in the Incentive processing project
• Responsible for gathering requirements from the Client for each module.
• Writing scripts to handle various Business Logics
• Point of contact for all the database related activities in the application
• Involved in the User Acceptance Testing and Bug fixing of the EIM system and played a vital role in solving production Issues for the developed system by gathering Business Requirement Document from Client Business Analysts
• Worked on Data Analysis in SQL server by validating and analyzing the data in the source system.
• Worked on scheduling and monitoring of the Informatica jobs and fixing the issues in the warehouse for the Asia-Pacific region of the project
• Worked on Cognizant Proprietary tools like E-tracker, Qsmart, Prolite and Cognizant 2.0 for Application Value Management and Project Management Activities.

Environment: Informatica Power Center8.6, Oracle 9i, Sql server 2008/ 2005

Confidential

Senior Oracle Developer

Responsibilities:

• Working as Database Module Lead at Offshore
• Worked on the database models and designing the table structures and responsible for database objects creation and maintenance
• Have developed PL/SQL Procedures and Packages specific for the projects.
• Prepared the packages for Load and Extraction Programs and worked on Data Analysis.
• Took ownership in performing the UAT during the project implementation
• Worked on the development of state specific response parser jobs; performed Unit testing and preparation of Test Reports.
• Coordinated with the QA and Onsite teams for the project deliverables.

Environment: Oracle 10g, Windows XP, QC

Confidential

Oracle Developer

Responsibilities:

• Involved in the preparation of Master and Detailed Test Plans
• Have experience in test Scenario Identification and environment set up
• Have Experience in coordinating client meetings and calls.
• Identify the bottlenecks in the queries that updates the Teradata database
• Co- ordinate with the OAT team, Functional Testing team and also with the Performance & capacity team for the performance reports.
• Analyzing the reports and provide Performance Improvement measures in the possible areas for the Teradata DB.

Environment: Oracle PL/SQL 10g, Teradata, HP UNIX 11i v2

Confidential

Oracle Developer

Responsibilities:

• Worked as Database developer.
• Co-ordinated for the Requirements gathering for the database creation.
• Created the required database objects.
• Developed procedures and functions for loading the assignments, exams and reports.
• Was a single point of contact for the Unit test, Production Implementation, Working on the release procedures and Post production support.

Environment: Oracle 9i, QC, MS Visio.

Confidential

Oracle Developer

Responsibilities:

• Created User requirement document for migration of the DB objects from Data mirror application to IBM CDC data capture.
• Created logical data models, recognize source tables and columns, to build Schema objects including Attributes, Hierarchies and Relationships necessary to the new migration environment.
• Involved in Design and Development of queries for the New IBM CDC data capture tool.
• Developed SQL and PL/SQL procedures and packages during migration of new version of the IBM Data Capture tool for the application Insight for which this tool is mainly used.
• Testing of the tool after deployment in the test environment.
• Fixing of the mismatches in the databases.
• Creation of new Insert, update and delete procedures during migration and whenever new tables are added to the Insight Application.
• Worked on the IBM Management Console tool which is the main component of the Data Capture application.

Environment: Oracle Pl/ SQL 9i, UNIX, and Windows XP, Mainframe Z OS V2R2, Informatica Power Center 7.1

Confidential

Oracle Developer

Responsibilities:

• Updation of the database with the client Information.
• Coding and testing of the scripts for DB Updation
• Fulfillment of Release procedures and preparation of status reports.

Environment: Oracle Pl/ SQL 9i, UNIX, and Windows XP, Informatica Power Center 7.1