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.

EXPERIENCE

Confidential

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

DOE office serves as a source for Delaware state education information. The Dashboard project developes an interface for elementary, middle and high schools about district level, school level and student level attendance, grades, assessments etc information.

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

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

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

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.
• Maintained the physical database by monitoring performance, integrity and optimize SQL Queries for maximum efficiency using SQL profiler.
• Managed index, statistics and optimizing queries by using execution plan for the tuning the databases.
• Implemented different types of constraints on tables.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Looked at the reports and fixed bugs in stored procedures.
• Deployed the generated reports directly on the client's workstation.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Identified and worked with Parameters for Parameterized reports in SSRS 2005.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• 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 department of 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

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.