We provide IT Staff Augmentation Services!

Sr. Programmer Analyst/data Warehouse Developer Resume

Overland Park, KS

PROFESSIONAL SUMMARY

  • Over 8 years of experience in System Analysis, design and development of database applications in Client/Server applications using SQL Server 2005/2008/2012 ,SSIS,SSRS,PL/SQL.
  • Strong technical skills across various RDBMS technologies such as MySQL, Oracle database, SQL Server, Analysis Services and Netezza database)
  • Experience with MPP and high performance data warehouse environments such as Netezza and Microsoft PDW (Parallel Data Warehouse)
  • Working knowledge of Apache Hadoop and developing with Hive and MapReduce
  • Profound knowledge and ability to write stored procedures, temporary tables, views, indexes, and triggers when required.
  • Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
  • Estimate, schedule and track ETL projects throughout SQL Server Agent and Job Activity Monitor.
  • Experienced on working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Proficient in Installing SQL Server 2000/ 2005/2008/2012 and configuration of their tools.
  • Good understanding in database and data warehousing concepts (OLTP and OLAP).
  • Experience in Data Warehouse Modeling with SQL Server Analysis (SSAS).
  • Experience in Creation and deployment of cubes on SSAS.
  • Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
  • Good Hand on Resolving complex issues and Error Handling in SSIS.
  • Very good knowledge in scheduling and deploying reports on report manger.
  • Experience in developing User reports and management reports using MS SQL Server Reporting Services (SSRS).
  • Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
  • Worked on predefined, developed stored procedures for automation and scheduling in crystal reports
  • Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using MicroStrategy, Tableau and SQL Server Reporting Services (SSRS).
  • Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
  • Experience in enhancing and deploying the SSIS Packages from development server to production server.
  • Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Highly motivated self-starter with strong troubleshooting skills, quick learner and excellent team player.

SKILLS

Operating Systems: Windows 2000 Server, Windows 2000 Advanced server, Windows 2003, Windows 2008, Windows NT 4.0, Windows XP, Windows Vista.

Environment: SQL Server 2005/2008/2012 ,Netezza,Microsoft PDW, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services, Web Reports, VS.NET, PL/SQL, Business Objects 4.0, XI 3.1/XI R2/6.x/5.x, WebI, Designer, Performance Manager, Dashboard Manager, Crystal Xcelsius.

Languages: C,C++, PL/SQL, T-SQL

RDBMS: SQL Server 2005/2008/2012 ,Netezza,Microsoft PDW, Oracle 11Gi

Application: MS SQL Server Management Studio, Business Intelligence Development Studio, MicroStrategy, Tableau.

Database Query Tools: MS SQL Server Query Analyzer, SQL Profiler, ETL, Toad for SQL

Database Software: TOAD,MYSQL

PROFESSIONAL EXPERIENCE

Client: Confidential, Overland Park, KS

Role: Sr. Programmer Analyst/Data Warehouse Developer

Job Responsibilities:

  • Participate in technology/tools evaluation and software technical proof of concepts.
  • Develop and maintain SQL Server 2008 databases including Business Intelligence (BI) tools
  • Create ETL processes using Microsoft SQL Server Integration Services (SSIS)
  • SharePoint 2010 development and including integration with SQL Server 2008 BI tools
  • Develop, and optimize enterprise-level data warehouses in SQL Server 2008
  • Develop custom report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using MicroStrategy, Tableau and SQL Server Reporting Services.
  • Assist end users in setting up Excel data cubes and using the PowerPivot add-in
  • Created Views for specific columns on a table to maintain privacy of a customer data.
  • Created Indexes to get the high level performance.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services (SSRS).
  • Experience in the design, development and maintenance of different cubes using SSAS.
  • Involved in the post deployment maintenance of reports and cubes and Created and scheduled jobs for various tasks.
  • Developing ETL Frame work to extract and load the data from multiple databases from SQL Server 2008 to File Server and File Server to work flow Job System SQL databases.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), MicroStrategy, Tableau, Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel.

Confidential, Mission, KS

Role: Data Warehouse Developer

Job Responsibilities:

  • Developed hospital measure analysis dashboard using Universe and WEBI.
  • Design and developed universe for measure analysis dashboard and reports.
  • Developed Pie charts, bar graphs, line graphs, comparative graphs and trend graph in WEBI reports.
  • Worked closely with account managers and business managers in calculating requirements for implementation on Business Objects 4.0.
  • Worked on Business Objects Security as per the Client requirement.
  • Developed Performance Management Dashboards to set goals, measures and monitor KPI for Balance Scorecard initiatives.
  • Created new Universes on Business Objects 4.0 relating to HR.
  • Worked on Web Intelligence 4.0, Crystal Reports Enterprise 4.0 and Dashboard Designer 4.0.
  • Experienced in BOE Migrations from BO XI and BO XI R2 to XIR3.
  • Developed documents like BOBJ Security, Xcelsius, Webi & Universe Designer etc.
  • Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
  • Designed SSIS packages for synchronizing the data between two different servers.
  • Maintained databases, performed software installations and upgrades, monitored Database Performance.
  • Responsible for gathering Business Requirements and System Specification from users.
  • Designed numerous ad-hoc and custom reports using SQL Reporting Services (SSRS).
  • Experience in the design, development and maintenance of different cubes using SSAS.
  • Involved in the post deployment maintenance of reports and cubes and Created and scheduled jobs for various tasks.
  • Developing ETL Frame work to extract and load the data from multiple databases from SQL Server 2008 to File Server and File Server to work flow Job System SQL databases.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, SQL Server Reporting Services, SQL Server Integration Services, Analysis Services, Web Reports, VS.NET, PL/SQL, Business Objects 4.0, XI 3.1/XI R2/6.x/5.x, WebI, Designer, Performance Manager, Dashboard Manager, Crystal Xcelsius.

Confidential, Cedar Falls, Iowa.

Role: SQL Server BI developer

Job Responsibilities:

  • Involved in creating the log files to track the bugs raised as a part of development and while in the production.
  • Identified damage on the general operational condition of bridges and monitored bridges structures using wireless sensor nodes
  • Analyzed the existing application and wrote technical specification document for the reports associating with the application.
  • Worked on WCF Service layer to retrieve data from the SQL Server.
  • Analyzed the requirements and created model classes accordingly to be used in the application.
  • Used Visual Studio 2005 BI tool to create SQL server reporting services (SSRS) reports.
  • Responsible for Database Script updates and Query writing related all the modules

Environment: Microsoft SQL Server 2005/2008, SAP business objects, Business Intelligence ETL Development Dashboard/Crystal Report, BI applications/Data Warehouse/Data structures, MicroStrategy, Programmable Logic Controller (PLC), Visual Basic/Oracle.

Confidential

Role: SQL Server Developer

Job Responsibilities:

  • Created Views to reduce apparent database complexity for end users and preventing sensitive columns from being displayed
  • Wrote Triggers and Stored Procedures.
  • Evaluated Database Performance and performed maintenance duties such as Tuning, Backup and Restore.
  • Scheduling Jobs and Alerting using SQL Server Agent.
  • Successfully designed and implemented SSIS packages to transfer data within servers.
  • Developed custom reports using SSRS/SQL Server BI studio.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Managing and configuring logins to SQL Server, database user accounts, permissions.
  • Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
  • Troubleshooting, Monitoring and Tuning the SQL Server for optimum performance.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), Management studio, SQL Server Integration Services (SSIS), SQL Server Business intelligence Development Studio(BIDS), T-SQL, DHTML, PL/SQL, TOAD v9.5, MS Excel.

Hire Now