Summary

• Over 7 years of experience on Database development Database modeling, Data design and technical management using SQL server 2005, 2008, 2008R2 and 2012 as a SQL developer and MSBI developer.
• Expertise in Microsoft Business Intelligence Tools BIDS like SQL server Integration services SSIS , SQL server Analysis services SSAS and reporting using SQL server Reporting services SSRS
• Expertise using complex T-SQL queries, store procedures, user defined function, triggers, user defined data-types, views and indexes.
• Expertise in using joins and Sub-queries to simplify complex Queries containing multiple tables and established relationships between tables using primary foreign key constrains.
• Experienced in designing Relational and Dimensional data modeling, data mapping RDBMS concept, Database management systems, physical and logical design, Data warehouses.
• Excellent knowledge in developing ETL packages using import/export utility, BCP, and SSIS packages.
• Expertise in developing and designing SSIS packages using control flow task and data flow transformations such as derived column, lookup, conditional split, merge, multicast, performance tuning in SSIS error and event handler using SSIS.
• Well versed with migrating Crystal Reports to SSRS reports using Crystal Report Migration Services.
• High expertise in creating reports using SSRS Ad-hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular, parameterized reports and cascade parameterized reports .
• Experience in design and implementation of On-Line Transactional Processing OLTP and On-Line Analytical Processing OLAP .
• Implemented MDX queries to design and develop cubes with facts, multiple dimensions, measures groups, KPIs, calculated members, perspective and hierarchies using SSAS.
• Experience in developing Dashboards and Scorecards using Microsoft Share Point 2010.
• Good experience in creating Pivot Tables and Charts in Excel using data sources like SQL Server, MS Access, SSAS cubes and power pivot.
• Capable of handling responsibilities independently as well as a team member.
• Have excellent communication and inter personal skills.

Skillset:

MS SQL Server 2012/2008R2/ 2008/ 2005, Analysis services SSAS , MS SQL server Integration Services SSIS , MS SQL Reporting services SSRS , Microsoft Access 2007/2003/8.0, Microsoft Excel, Outlook, MSSQL profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Erwin Data Modeler 7.1/5/4,VB6, MS SharePoint, Microsoft products MS Word, MS Access, MS Excel, TFS/VSS, MS Access, MS Power Point, T-SQL, PL-SQL,HTML, XML, C , C , VB.Net, Crystal Reports 8.5, MS Visio 2003, Windows 2003/2000 Advanced server/professional, Windows NT 4.0 Server/work station.

Confidential

MS SQL Server/SSRS/SSAS/SSIS Developer

• Confidential is a tri-jurisdictional government agency that operates transit service in the Washington Metropolitan Area. WMATA was created by the United States Congress as an interstate compact between the District of Columbia, the State of Maryland, and the Commonwealth of Virginia.
• The clients Legacy web application SQL server 2008 is being converted to the new web application SQL server 2012 Database. The current system interface, reports and files transfers handled by the host application, needs to be developed for the new SQL server 2012 application. This required analysis of existing system, interaction with business user to determine the needs, modifications and new methods of sending and receiving files.

Responsibilities:

• Designed and developed Database solutions based on functional requirement.
• Migrated the existing application/Databases to MS SQL Server 2012.
• Going through the clients' requirement coming up with Database design and application architecture. Plan capacity specification requirement for new Database server.
• Developed Logical and physical data model using ERWIN and mapped the data into Database objects.
• Wrote T-SQL scripts, store procedures, User defined functions, views to extract data.
• Designed and Created different .DTSX packages to SQL Server 2008 source to SQL Server 2012 as destination to import and export data from Flat files, Text files, Excel spreadsheets. Using transformations such as data conversion, fuzzy look-up, conditional split, derived column transformation.
• Managed and deployed SSIS packages on file system or SQL management studio using SSIS
• Implemented data Integration processes to handle XML files generation or processing.
• Created variety of reports using SSRS including matrix report, parameter report, dashboard, charts, drill-down, drill- through, cascade parameterized report, configured report server and deployed reports on the web server with SharePoint.
• Generated daily, weekly, monthly and Dashboard reports for analysis purposes and also created report models for ad hoc reports when the end user wants to see the reports on fly using SSRS.
• Designed and implemented indexing to optimize transactional and reporting performance.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

Environment: Windows 7, MS SQL server 2008/2012, MS SQL SERVER Reporting services 2012, MS SQL Integration Services 2012, SQL Server Analysis services SSAS , T-SQL, and ERWIN, Share Point.

Confidential

MS SQL Server, SSIS/SSRS/SSAS Developer

Confidential is a financial industry that provides financial service and solution for its clients. The project was completed in two phases in the first phase it involved developing and testing the SSIS packages to deal with high volume processing output loading data from different system into Data warehouse. The second phase was to create the Analytical report for business users to understand the growth of business and better decision making.

Responsibilities

• Developed mapping databases for ETL team with source to target data mapping with physical naming standards, data types, domain definitions, and corporate meta-data definitions.
• Developed SSIS packages to Extract, Transform and load data to Data warehouse with different control flow options and data flow transformations such as conditional split, multicast, Union all, for each loop, send mail and derived column.
• Created SSIS packages for file transformation from one location to other using FTP task, with master SSIS package to run all other packages.
• Used dynamic package configuration to move the package from development server to the testing server.
• Used Bulk Copy Program BCP to import and export large amount of data in and out of SQL Server Databases.
• Performed SQL performance tuning using SQL Profiler and query optimization to improve the performance of slow running queries.
• Created and used complex store procedure in SSRS to generate reports using SSRS.
• Developed and designed various forms of Reports like Drill down, Drill through, parameterized, cascade parameterized reports using SSRS.
• Designed and developed snowflakes and star schema data models with facts, dimensions, measure and cubes, also established data granularity using SSAS.
• Scheduled Jobs, Alert, and Subscriptions using SQL Job Agent in SQL Server management studios.
• Design KPIs, Filters, Reports, Scorecard and Dashboards reports Using PerformancePoint on Share Point.
• Worked on Agile methodology and Microsoft Team Foundation Server TFS as a central server product where software team members connect and collaborate efficiently for a successful software project.

Environment : SQL Server 2008R2, T-SQL, MS Access, MS- Excel, and windows server 2003 server, business intelligence tools Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, SharePoint.

Confidential

MS SQL Server/SSIS/SSAS/SSRS Developer

Confidential, is a nonprofit managed care organization that provides healthcare coverage to individuals and families in New York service areas through low-cost or free government-sponsored health insurance programs, including Child Health Plus, Family Health Plus, Medicaid, and Medicare Advantage. The project was to build an objective to help top level management in decision making. The data from different department is collected and integrated into Data Mart that are built based on subject areas.

Responsibilities

• Worked on designing the SSIS packages to transform data various sources like Text files, XML files, Excel, Flat files to SQL server 2008R2.
• Used Execute SQL task, Execute Process task, Execute SSIS package task and Script task, File System task.
• Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.
• Created and used stored procedures, triggers, views for Audit and Maintenance tasks.
• Designed and developed various reports such as cascading reports, sub-reports, and charts, parameterized reports as per client requirements.
• Monitored performance and optimized SQL queries for maximum efficiency using SQL profiler and Database Engine Tuning Advisor.
• Created cluster and non-cluster indexes based on Database Engine Tuning Advisor
• Worked on client/server tools like SQL Server Enterprise manager and Query Analyzer to administer SQL Server and used SQL Server system tables to retrieve metadata.
• Developed bug/data fixes and maintained data integrity.
• Worked with OLTP, OLAP, Data warehouse application, star schema and snowflakes schema dimensions.

Environment: MS SQL Server 2008R2, Business Intelligence Studio Integration Services, SQL Server Report services, Windows 7, Microsoft Access, Microsoft Visio

Confidential

MS SQL server/SSRS Developer

Confidential is a financial company that provides financial and mortgage service to its customers. Objective of the project was Migration of SQL server 2000 to SQL server 2008 and collect data from various Database source to create Reports using SQL server 2008 reporting services.

Responsibilities

• Worked closely with business units to understand key business and identify the individual business metrics and key measures that support them.
• Designed and configured parameters, settings, metrics, data elements and objectives
• Wrote complex SQL queries using join, store procedures, used defined functions to verify the data from the Database to generated reports based on the financial requirement.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports using SQL server 2008 reporting services
• Administrated and schedules data driven mailing subscriptions on SSRS reporting server
• Migrated existing Crystal reports to SSRS reports using Crystal Report Migration Services.
• Production parameter driven, matrix sub-reports and integrated report hyper-link functionality to access external applications
• Created dashboard SSRS reports server projects and publishing SSRS reports to the reports server tabular and matrix reports with aggregator functions and expressions.
• Developed functional technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS data models projects using Microsoft Visual Studio 2008 and using Reports Builder for report server to facilitate Ad-hoc reporting by the business user.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, T-SQL, SQL-Server Management studio 2008, Business Intelligence Development, Visio, Excel 2003, SharePoint

Confidential

MS SQL Server /SSRS developer

Confidential is a privately held financial software, data and media company headquartered in New York City. It provides Data services and news to financial companies and organizations through the Bloomberg station. The project was to build Customer-Center Database to analyze transaction across financial, marketing, risk, collections and customer relations were developed

Responsibilities

• Created new Database objects like procedures, functions, packages, triggers indexes and views using T-SQL in SQL Server 2005
• Created ER diagrams for easy understanding of the data using MS Visio.
• Managed logins, roles, assigning rights and permissions. Created views to implement security.
• Developed reports using SSRS using various features like cross tab, parameterized reports as per client requirements.
• Have written several stored procedures and trigger for financial purpose.

Environment: MS SQL Server 2005, T-SQL, MS Excel X32 and X62 , windows XP, SQL Server BI Suit, C , Microsoft Visio, SSRS