We provide IT Staff Augmentation Services!

Business Intelligence Programmer/project Lead Resume

SUMMARY

  • Highly motivated, enthusiastic team player and accomplished as a mentor wif extensive IT experience of over 10 years as a Dashboard/ Complex Reports Developer, expertise in creating ETL packages using SSIS, Informatica and subject matter expert (SME) across different domains such as - Healthcare, Financial services, Banking.
  • Excellent knowledge on Data warehousing concepts wif specialization in designing and implementing enterprise business intelligence reporting solutions, leveraging advanced reporting and visualization tools like SSRS,IBM COGNOS suites, Tableau, Power BI.
  • Having 10+ years of Exp. on development, maintenance, enhancements in ETL/ SQL/Reporting and MSBI (SSIS, SSRS, SSAS) and past experience on Informatica.
  • Persistently worked wif higher level management for requirement gathering and was able to juggle on multiple projects.
  • Exceptional understanding of Business Intelligence and Data Warehouse concepts.
  • Mentored new hires on teh business knowledge and existing projects.
  • Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support.
  • Created multiple SSIS packages for loading of data using various transformations.
  • Worked on building cubes and resolving failures in SSAS.
  • Created several reports using SSRS.
  • Has creative problem solving skills, quick and independent learning skills.
  • Proficient in programming languages SQL, PL/SQL.
  • Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
  • Created many packages using SSIS to perform ETL.
  • Knowledge on data warehouse concepts like star schema, snow flake schema, dimension and fact tables.
  • Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
  • A team player highly motivated, energetic wif excellent communication and interpersonal skills.

TECHNICAL SKILLS

LANGUAGES: SQL,PL/SQL

RDBMS: SQL Server 2008,2008R2,2012,2014,Mongo DB

OPERATING SYSTEM: UNIX, Windows (95/98/00/XP, Vista)

PACKAGES: TOAD 7.x, SSMS, SQL Navigator 4, SQL* PLUS

ETL: SSIS,Informatica Power Center 8x/7x, Mainframe

TOOLS: SSRS,COGNOS,Tableau,Visual Source Safe, Autosys,Tivoli, TFS,HPQC,HPALM

WEB TECHNOLOGIES: HTML, XML,JSON

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Programmer/Project Lead

Environment: SQL SERVER 2014,SSRS,SSIS,Mongo DB

Responsibilities:

  • Single-handedly took over teh project and successfully pulled over teh project for almost 1 year and greatly appreciated by higher level management.
  • Delivered critical data analytics for teh business on day to day basis and met back to back timelines wif efficient and accuracy.
  • Constantly worked wif business to gather teh requirements and prioritize teh work to meet teh timelines.
  • Persistently worked and coordinated wif higher level management to understand teh domain knowledge of ICBT programs and data in depth.
  • Created SSIS packages for extracting data from mongo db and import it to sql server using teh third tool.
  • Played an instrumental role in gathering requirements and has modelled teh database for teh project.
  • Created multiple and complex reports and delivered them for critical purposes.
  • Involved in brainstorming session wif DBA’s and architects to resolve teh database performance issues and drastically improved teh report run time.
  • Provide governance to teh review processes and effectively communicate out project status.
  • Designed teh data flow diagrams using VISIO
  • Proactively helped teh team in resolving high priority tickets and meet teh deadlines.

Confidential

Business Intelligence Programmer

Environment: SQL SERVER 2008,SSRS,SSAS,SSIS

Responsibilities:

  • Dealt wif teh data pertaining to Disability Management services and absences related to Healthcare.
  • Gather requirements and design of data warehouse and data mart entities. Created Datamarts on top of teh database.
  • Involved in creating teh scripts for datamart design.
  • Created SSIS packages for cleansing of teh data.
  • Created cubes in SSAS and wrote many mdx queries to extract teh data from cubes.
  • Created many stored procedures for each of teh chart in SQL to send teh data to reporting from cubes.
  • Reviewed and tested all teh procedures for accurate results.

Confidential

Business Intelligence Programmer

Environment: SQL SERVER 2008,SSRS,SSIS,Birst

Responsibilities:

  • Took initiative of mail box and fixed teh issues related to reports.
  • Plan, design, and implement application database code objects, such as tables, stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Perform quality assurance and testing of SQL server environment.
  • Involved in debugging teh procedures and fixing teh issues.
  • Developed ETL processes to export data from Excel to SQL server and perform transformations using SSIS.
  • Created many reports using SSRS and manual reports as well using Excel.
  • Automated few monthly reports which are done manually.
  • Involved in migration of projects from SSRS to Birst.
  • Thoroughly reviewed teh code as well as teh documents for teh project.

Confidential

Sr.ETL Developer

Environment: SSAS,SSIS,SQL SERVER 2008,SSRS

Responsibilities:

  • Involved in gathering ETL requirements and analyzed using various sources to fulfill teh customer's needs.
  • Participated in defining teh clearest possible terms, teh problem dat teh project is expected to solve wifin teh given time.
  • Achieved coding standards bythe design specification and doing code review.
  • Developed and tested extraction, transformation, and load (ETL) processes.
  • Developed teh cubes on teh SQL Server database using MSBI SSAS tool and teh dashboards were developed using share point server (PPS) by making use of cubes.
  • Involved in creating procedures, functions and views for teh ETL purpose and thoroughly reviewed to retrieve teh required data from teh client data base accurately according to teh requirements.
  • Prepared teh technical design documents and cube scheduling document given to teh client.
  • Written test cases from teh development site to check teh accuracy of teh code written for ETL.
  • Solid Back End Testing experience by writing and executing SQL Queries
  • Prepared LLD documents for teh project.
  • Extensively worked on teh performance tuning of Stored Procedures.
  • Actively participated/lead everyday Scrum meetings in teh Agile development of teh project.
  • Involved actively in resolving issues reported by client during UAT.
  • Proactively helped teh Support team in resolving high priority tickets.

Confidential

ETL Developer

Environment: SSAS,SSIS,SQL SERVER 2008,SSRS

Responsibilities:

  • Responsible for gathering requirements from customer/onsite coordinator.
  • Coded procedures, functions and views to retrieve teh required data from teh client data base accurately according to teh requirements.
  • Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS).
  • Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
  • Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
  • Designed complex SSAS solutions using multiple dimensions, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
  • Involved in designing and preparing Test Scenarios, Test Plans, Test Cases.
  • Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
  • Performed Unit Testing, Integration Testing (SIT), User Acceptance Testing (UAT).
  • Executed Test Cases wif respect to Source and Target database tables.

Confidential, Los Angeles

Informatica Developer

Environment: Informatica8.6, Oracle9i, PL/SQL, UNIX, Tivoli Workflow Scheduler TWS, Autosys

Responsibilities:

  • Involved in analysis of teh impact, working on teh ETLs and teh UNIX scripting to in corporate teh code change for teh same.
  • Worked wif Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
  • Call stored procedures in oracle as pre SQL session.
  • Work on SQL tools like TOAD to run SQL Queries to validate teh data.
  • Involved in changing teh layout of existing mainframe files, so all teh impacted ETLs are being modified to accommodate these requirements.
  • Participated in coding and testing for teh ETL objects.
  • Prepared teh functional test cases and conducted code review sessions.
  • Performed UAT and Regression testing.
  • Automated and scheduled teh Informatica jobs using Tivoli and Autosys.
  • Migrated mappings, sessions, and workflows from Development to Testing and tan to Production environments.
  • Prepared teh LLD and carrying out impact analysis.

Hire Now