We provide IT Staff Augmentation Services!

Sr. Ssis Bi Consultant Resume

Dover, DE

SUMMARY:

  • Over 9 years of IT experience, which includes functional and technical expertise in Business Intelligence.
  • More than 7 years of extensive experience of MS SQL server with Business Intelligence in SQL server reporting services, SQL server Integrating services, SQL server analysis services (SSAS, SSIS & SSRS).
  • More than 2 years of extensive experience of MS SQL Data Base Administration (DBA).
  • Extensively worked with financial clients and have excellent knowledge in Credit Risk area in asset management. Dealt with counterparties, equities, derivatives, treaties and insurance related parameters.
  • Excellent technical and analytical skills with clear understanding of design goals of Dimension Modeling for OLAP and Entity Relationship Modeling (ER Modeling) for OLTP and expertise in using with modeling tools Erwin and Visio .
  • Expertise in using ETL tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS). Expert in creating dimensions, fact tables required for designing Cube using SSAS.
  • Worked on Creating Error Handlers for debugged the packages in SSIS.
  • Demonstrated expertise in creating different type of reports like parameterized reports, linked, drilldown, drill through, sub reports,dash boards using reporting tools like using Intellisys, SQL Server Reporting Services(SSRS).
  • Worked with Quality Center and FogBugZ tools for created tickets, bugs or new features.
  • Worked in a team environment using Team Foundation Server (TFS) and GIT. Packages and Reports were checked - in and checked out after making changes.
  • Excellent experience in working with different Control flow and Data flow tasks and creating packages using SQL Server Integration Services (SSIS).
  • Worked with BI objects such as Basic InfoCubes, ODS, Real-Time and Write-Optimized DSOs, MultiProviders, InfoSets (Info-providers), DataSources, InfoPackages, InfoSources, Transformations, Data Transfer Processes (DTPs).
  • 3+ years of experience in WebForms and applications using ASP.NET with C#, AJAX
  • Expertise with T-SQL in writing complex queries, triggers, tables, user functions, views, indexes, partitions, user profiles, relational database models, data dictionaries, and maintaining data integrity.
  • Worked on creating Transaction Logs for storing the changes made while performing the ETL
  • Experience in developing and integrating a JDBC SAP adapter to a Composite Information Server for virtual data integration.
  • Experienced in data dictionary, Data source Enhancement, OLTP extraction data and loading.
  • Knowledgeable in programming using scripiting languages like PERL and shell scripting.
  • Expert in reporting using Intellisys, Reportrak, Crystal Reports, Business Explorer, and Web Application Designer. Experienced in implementing Queries, Calculated and Restricted Key figures/measures, variables, workbooks, security roles, web reports and profiles.
  • Handson experience in building ETL jobs using Business Objects Data Integrator.

AREAS OF EXPERTISE:

Database: SQL Server 2000/2005/2008/2012

SQL DBA, T-SQL,: Installation, Upgrade, & Migration

Extracting, Transformation and Loading (ETL): SQL Server Integration Services (SSIS) and DTS

SQL Server Reporting Services (SSRS): Hyperion Crystal Reports 10

SQL Server Analysis Services (SSAS): Hand on experience with SQL Server Replication, Log Shipping, Failover Clustering, Database Mirroring

Operating Systems: Windows Enterprise 2003/2000 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional, Windows Vista, Windows 7

Applications: Erwin 3.5/4.1/7, Microsoft Visio, Visual Studio 6.0/.NET/ 2005/2008/2010 , Team Foundation Server

Language: C, ASP.NET, C#, HTML, XHTML, XML, CSS, PHP, JavaScript

Protocols: HTTP, TCP/IP, FTP Administering

Database Engine: Security, Managing SQL Servers, Managing Large Databases, Linked Server, High Availability, Importing Exporting Bulk Data, Backing up Restoring, Deploying Application

Packages: MS Office 2007, MS Office Excel, MS Power Point, Access

EXPERIENCE:

Confidential, Dover, DE

Sr. SSIS BI Consultant

Enviornment: MS SQL server 2008 R2/2012, Microsoft Integration services, MS Visual Studio 2008, FogBugZ, Team Foundation Server, GIT, Windows PowerShell

Responsibilities:

  • Expertise in analyzing Dashboard and Legacy Data System (LDS) project business requirements, needs and objectives
  • Developed data modeling for the application and created ER diagram using ERWin.
  • Created SSIS packages to Extract, Transformation and Load (ETL) students Attendance, Grades, Assessment, Discipline information from other database (EdFi, iMart etc).
  • Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure. Modified existing packages for current year
  • Created packages for pulling data from multiple sources such as XML, OLEDB, text files into SQL server database using SSIS for LDS project.
  • Created bugs, new features using FogBugZ tool. The complete status is maintained until the issue is resolved.
  • Developed SSIS packages using Team Foundation Server (TFS) as well as GIT tools. GIT is popular distributed version control system (DVCS).
  • Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.
  • Managed health of SQL Servers including backups, restores, monitoring
  • Various performance techniques were applied to the data warehouse system (partitions, aggregates, efficient dimension design, chaching)
  • Designed and Implemented SQL Server database objects (stored procedures, functions, views, complex T-SQL/queries) to support data integration (SSIS), analysis, and various business processes.
  • Maintained power shell script to batch SSIS packages using SQL server agent.
  • Documented all SSIS packages, reports. They were shared using google docs among our team.
  • Developed and maintained enterprise reporting (SQL Sever Reporting Services / Crystal Reports) based on specifications and business needs and modified existing reports as needed.
  • Conducted peer-review on existing stored procedures/functions and performed optimization.
  • Developed quality control reports (benchmarking, trending, etc), identified and performed root-cause analysis for any data anomalies to support both ad hoc and client analytical reporting needs.
  • Communicate with project managers as to the progress of open items and work with other developers.
  • Working closely with the users supporting the existing reports and creating new reports.

Confidential, New York, NY

Sr. SSIS BI Consultant

Enviornment: MS SQL server 2005/2008, Microsoft Integration services, MS Visual Studio 2005/2008, MS SQL server DBA, Cygwin, Quanlity Center, Risk Modeling, C#.NET

Responsibilities:

  • Expertise in analyzing Counterparty Credit Risk business requirements, needs and objectives
  • Conversant in the Fixed Income and Equity trading (OTC) technologies
  • Developed data modeling for the application and created ER diagram using ERWin.
  • Developed the datawarehouse comprising of dimensions and facts and realtionsships using sqlserver 2005.
  • Reviewed and tuned SQL queries, stored procedures, views, triggers
  • Created packages for pulling data from multiple sources such as XML, OLEDB, text files into SQL server database using SSIS.
  • Worked on different control flow and data flow tasks and created packages for extract, transformation and load (ETL) processes using SSIS.
  • Implemented the calculations to aggregate physical measures.
  • Defined relationships between Measure groups and Dimensions.
  • Worked on Direct Hedge Fund cube, Privite Equity cubes using SSAS and wrote MDX queries to query cubes to access cube's data.
  • Designed and Implemented SQL Server database objects (stored procedures, functions, views, complex T-SQL/queries) to support data integration (SSIS), analysis, and various business processes.
  • Production support for CCR project. SSIS packages were batched for automatic run for QA, UAT and Production using Control-M, SQL Server Agent and Data Load Tool
  • Worked with users from Zurich and New York to keep updated with business requirements.
  • Worked on tickets created using Quality Center by users, business analysts.
  • Developed and maintained enterprise reporting based on specifications and business needs and modified existing reports as needed.
  • Conducted peer-review on existing stored procedures/functions and performed optimization.
  • Developed quality control reports (benchmarking, trending, etc), identified and performed root-cause analysis for any data anomalies to support both ad hoc and client analytical reporting needs.
  • Planned, performed, and directed on QA test plan through usage of various test case scenarios.

Confidential, Englewoodcliffs, NJ

Sr. SSIS/SSAS Consultant

Enviornment: MS SQL server Analytical services, Microsoft reporting services, OLAP, OLTP, MS Visual Studio 2005/2008, Reportrak, TrakNow, MS SQL server 2005/2008, Intellysis, DBA.

Responsibilities:

  • Expertise in analyzing the customer business requirements.
  • Performed various project tasks in the development life cycle including requirement, analysis, design, development, and testing. (SSIS package, monthly data integration, enterprise reporting).
  • Designed the datawarehouse using dimensional modeling and developed DSMP cube, Front office combined cube, and back office cubes.
  • Developed the datawarehouse comprising of dimensions and facts and realtionsships using sqlserver 2005.
  • Created packages for pulling data from multiple sources such as XML, OLEDB, text files into SQL server database using SSIS.
  • Worked on different control flow and data flow tasks and created packages for extract, transformation and load (ETL) processes using SSIS.
  • Created Error Handler and debugged the packages in SSIS.
  • Created highly visual dashboards that can keep the business upto date about the customer organization and allows to take decision making quickly.
  • Developed and maintained enterprise reporting (SQL Sever Reporting Services / Crystal Reports) based on specifications and business needs and modified existing reports as needed.
  • Designed parameterized queries, sub reports, drill through, drill down, linked reports using SSRS 2008
  • Developed quality control reports (benchmarking, trending, etc), identified and performed root-cause analysis for any data anomalies to support both ad hoc and client analytical reporting needs.
  • Documented manual for Reportrak which is used to create packages, cubes, reports, dash boards, grids, charts etc.

Confidential, San Mateo, CA

Sr. BI Consultant

Enviornment: MS SQL, JDBC4OLAP, Composite Information Server (CIS) and Studio 4.5/4.6, MDX, XMLA, SQL Plus, DBA, SSRS

Responsibilities:

  • Developed a JDBC BW/BI adapter which integrates Composite Information Server (CIS) to SAP system. CIS is a multi-threaded, Java-based server that non-invasively, accesses existing data from disparate sources, then, combines, abstracts and simplifies the complex data, and delivers it via web services or relational views.
  • Maintaining SQL databases, performance turing, creating roles.
  • Created packages for pulling data from multiple sources such as XML, OLEDB, text files into SQL server database using SSIS.
  • Worked on different control flow and data flow tasks and created packages for extract, transformation and load (ETL) processes using SSIS.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for Parameterized reports in SSRS 2005.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Deployed the generated reports directly on the client’s workstation.
  • Looked at the reports and fixed bugs in stored procedures.
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Implemented different types of constraints on tables.
  • Managed index, statistics and optimizing queries by using execution plan for the tuning the databases.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL Queries for maximum efficiency using SQL profiler.
  • Worked with business users to gather requirements for complex reports and develop queries, work books and web based dash boards .
  • Extensively worked on STATS report. It’s a statistical analysis report required by the Confidential transportation.
  • Generated a Report for extracting Payroll Results (Gross Pay and Net Pay) of Employees for specific Pay Periods, medical, 401k, retirement plans and pensions.
  • Modified existing queries based on change request and saving query results with different criteria for supporting different business scenarios.

Confidential, Freemont, CA

Sr. SQL BI Developer

Enviornment: Microsft SQL server 2005, SQL server Integration Services (SSIS), OLAP, OLTP, MS Visual Studio 2005, NET Framework, ASP.NET, C#, SSRS, SSAS, Windows XP

Responsibilities:

  • Expertise in gathering customer business requirements, needs and objectives. Participated in regular meetings with users and business analysts to finalize the requirements for the implementation of business intelligence suite (BI Suite)
  • Created packages for extracting data from various sources such as XML, OLEDB, text files into SQL server database using SSIS.
  • Experienced in disater recovery, risk analysis with various financial clients.
  • Worked on equities, derivatives, Treaties, Claims, and accounting reports.
  • Debugged and deployed the generated reports directly onto the client’s workstation.
  • Worked on different control flow and data flow tasks and created packages for extract, transformation and load (ETL) processes using SSIS.
  • Created Error Handler and debugged the packages in SSIS.
  • Maintained table performance by following tuning tips like normalization, creating indexes and collect statistics.
  • Adapter is able to convert SQL to MDX while connecting to BI system and converts back MDX-SQL to give output.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
  • Scheduled jobs for backup, and created alerts for error reporting.
  • Generated automatically grouping attribute members.
  • Defined granularity with in a measure group and drill through actions.
  • Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
  • Successfully tested the performance of the adapter. The adapter is tested for different load size using SQuirreL (SQL plus client).
  • The connectivity from the frontend to the backend was done by using JDBC. All the business logic were implemented by using Core Java.
  • Responsible for all aspects of data loading, modeling, spoking, and reporting in BI and data-staging (SQL-based) environments.

Confidential, Menlo Park, CA

SSIS/SSRS

Enviornment: Microsoft SQL server 2005, Performance point server, SharePoint, SSIS/SSRS, SAP, MS Visual Studio 2005, Business Objects

Responsibilities:

  • Involved in complete life cycle including requirement gathering, technical specifications, system design, database design, presentation layer and deployment.
  • Extensive experience in creating patience diagnostic reports, patience helath history and pharma industy internal reports using SQL reporting services (SSRS).
  • Performed Replication of Data (Transactional method used).
  • Experienced in writing stored procedures/functions/triggers using SQL server 2005.
  • Desingned Facts,Dimensions, Hierarchies and Models using datamodelling tool ERWIN.
  • Deployed dashboard to Microsoft Office SharePoint Server 2007 and then exported the dashboard to Excel.
  • Extensively worked with various control and data flow tasks to suit for the pharma industry.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans with SSIS for proactively monitoring the performance of SQL Server databases
  • Designed charts, reports and dashboards using reporting services (SSRS)
  • Created highly visual and interactive scorecards regarding day to day activities of Confidential .
  • Created key performance indicators that can help business to monitor things as progress on a specific initiative and progress against sales forecasts.
  • Defined score cards, dash boards and KPIs using performance point server
  • Worked with SAP Team to cover the Transformation areas.
  • Designed a dashboards which is a collection of graphs, reports, scorecards and key performance Indicators (KPIs).
  • Created same scorecards using Excel with cube member and cube value functions in order to give business different variety of taste.
  • For few users, business migrated from BEx report to WebIntelligence XI R2.
  • Involved in validating those reports converted to BOXI R2 for Consistency of Data and Discrepancies and also enhanced them as per the User Requirements.

Confidential, Princeton, NJ

MS SQL Developer

Enviornment: Microsft SQL server 2005/2000, SSAS, SSIS, SSRS, Visual Studio, ASP.NET, C#

Responsibilities:

  • Extensively worked on SQL Server Integration Services to design a data flow for Migration of data from SQL Server 2000 database to SQL server 2005 database
  • Provide simple, user-friendly reports that assist in the analysis of data using SSRS (SQL Server Reporting Services)
  • Worked on Treaties, Claims, treaty related groups, related text description and accounting.
  • Responsible for the creation of reports/cubes using SQL Server 2005 Reporting Services and Analysis Services
  • Created Stored procedures for Partitioning the Data warehouse based on 24 months sliding window and to provide the custom log table along with the packages
  • Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production
  • Created Several Scripts in ASP.Net to generate customized script Tasks and to generate Surrogate Keys
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Created Extract Structure, Transfer Structure and Replicated Data sources, and maintained Transfer rules for Communication Structure and also defined update rules. Prepared daily billing report, shipping report, revenue trend, Sales, Service, Contract, Version Comparison, Plan and Actual Revenue etc.
  • Created reports based on Forecast and estimation. Created Queries on Masterdata Hierarchies.
  • Worked on Creating new data targets, Creating Custom Data Sources, and tables, View, SAP Query, Function Module.

Confidential

IT Programmer

Environment: XML, ASP, MS SQL server 2000, DBA, Visual Basic, Windows 9x/NT, Unix

Responsibilities:

  • Designed and implemented several complex reports and administration modules.
  • Designed VB forms using the forms and crystal reports were made for business reporting purpose.Involved in designing an administrative login to generate reports on the users and their profiles.
  • Developed portable and customizable server controls module for menu bar, collapsible menus, etc with XML or database as datasource.
  • Designed and developed ASP.NET pages in the Event Administration and Reporting modules.
  • Involved in unit testing, integration of all the modules, stress testing and deploying it on client side.
  • Created maintenance tools, such as a web-spider with Perl and MySQL to monitor web pages
  • Proposed sound solutions to user requirements and exercise judgment within generally defined practices and policies in selecting methods for obtaining solutions.
  • Developed the print program and SAP Script form for printing sales confirmation, Invoices in sales & distribution

Hire Now