SUMMARY

• Proven ability in working with enterprise level large data warehouses, RDBMS systems, and ETL and modeling tools/techniques.
• Excellent in data mining for fulfilling customer segmentation business requests and periodic report generation.
• Worked with different source systems like Teradata, Oracle 10g and Microsoft SQL Server. Thorough knowledge and understanding of Dimensional Data Modeling, Star schema, Snow - Flake schema, creation of Fact and Dimension Tables, OLAP, OLTP and other Data-Warehousing concepts.
• Well versed with data movement and data conditioning within cross platforms.
• Excellent in writing highly complex and well-tuned SQL queries to fulfill ad-hoc and strategic data segmentation requests.
• Excellent knowledge in the areas of financial and banking domain.
• Created numerous reports using Pivot tables (Excel).
• Extensively used Business Objects for the purpose of reporting.
• Ability to understand the business from various points of view due to diverse experiences as Programmer Analyst, Business Analyst and Marketing & Strategic Planning Analyst.
• Dynamic cross-functional team player, result-oriented, fast learner, excellent written and verbal communication skills with strong research capability. Excellent problem solving, conflict resolution, analytical and presentation skills.
• Experienced in working with tools like Server Management studio and SQL plus for development and customization
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0 and 9.2 as a Developer and Analyst
• Experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.

TECHNICAL SKILLS

Platforms: Win XP, Vista,7, Unix

RDBMS: Oracle 11g, SQL SERVER 2008/2012/2014

Data Modeling Tools: MS Visio, Erwin, ER Assistance

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Querying Tools: SQL Server Management Studio 2008, Oracle 10g/11g,Teradata SQL Assistant, SQL Plus, SQL Developer

ETL/Business Intelligence tools/Programming languages.: Informatica 10.2/ 9.5.1/9.6.1 , Tableau 9, 10

PROFESSIONAL EXPERIENCE

Confidential, NJ

ETL Informatica Developer

Responsibilities:

• Develop workflows to migrate patient’s information into a master patients table within the data warehouse for reporting purposes
• Converting SQL Script to informatica mapping.
• Designing and developing ETL with informatics power center processes for data warehouse; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatics scheduler to schedule jobs
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Confidential, Newark, NJ

ETL Informatica Developer/ Data Analyst

Responsibilities:

• Designing and developing ETL with informatica power center processes for data warehouse; from the acquisition and staging of data, storing records within the warehouses historical archive and transforming records for loading into the reporting tables
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs
• Created business rules in Informatica Developer and imported them to Informatica power center to load the standardized and good format of data to staging tables.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Creating ad hoc queries, stored procedures, and programming scripts with SQL
• Utilizing Informatica for ETL data modeling, data migration, integration, and analysis
• Pulling data from Facets and Nasco claims systems to create operational reports for applications
• Supporting data profiling activities
• Supporting logical data designs/models by reviewing with Business stewards
• Working with member eligibility data, demographic data, claims (Medical, Dental, Pharmacy) data, premiums data by pulling from BCBSAL data warehouse and generating day-to-day reports in support of the Actuarial Finance department for pricing, catastrophic actuarial analysis and other purposes
• Identifying data and solution patterns as well as taxonomies
• Creating source to target mapping at the element level including specifications for data integrity, referential integrity in support of the Actuarial Finance Systems

Confidential, Pittsburg, PA

Data Analyst/Tableau Developer

Responsibilities:

• Fulfilled numerous data request for financial profiling.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Thorough analysis, unit testing and integrated testing with other applications of database objects & T-SQL statements before deployment to the production server.
• Created and maintained views within SQL server for Business Analysts.
• Wrote highly complex but well-turned SQL queries using SQL assistant to run departmental reports within Teradata platform.
• Compiled 10 years of historical data to construct deposit profile.
• Created a deposit data-mart and created views on top of that.
• Involve in Designing High level Technical Documentation based on specification provided by the Manager
• Developed and retrieved various Ad hoc reports for the finance to match on deposit numbers.
• Data validation and data cleansing.

Confidential, Knoxville TN

Data Analyst/ETL Developer

Responsibilities:

• Created metadata and approval documents for the project.
• Acted as a SQL tuning expert for the team.
• Created an automated daily ETL (Extract, Transform& Load) process using SSIS
• Worked with the testing team to resolve bugs related to ETL mapping before production
• Responsible for developing, supporting and maintenance for the ETL process using SSIS
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using SQL Server, oracle SQL, procedures, packages, functions, database triggers.
• Extract data from flat files, Oracle, DB2, and SQL Server 2012, and to load the data into the target database.
• Developed and maintain logical and physical models for database in DB2, Oracle and SQL server using ERWIN Data Modeler
• Performed forward and reverse engineering process to create DDL scripts or physical Data Models. Created ERWIN reports in HTML, RTF.
• Created pivot tables in Excel by getting data from SQL Server and Oracle.
• Created Transformations and Mappings using Derived Column and mapping tools in SSIS and processing tasks in the Data Flow task to move data from multiple sources into targets.
• Maintained data consistency, database integrity and reported instances of data corruption.
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects reports.