SUMMARY:

• 10.6 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Very Good Understanding and Experience in SQL Server Integration Services(SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services(SSRS)
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions. Extensively worked in Data Modeling using Erwin.
• Experience in Feeding data On OLTP and OLAP system using SQL server integration service.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS),Data Modeling like Dimensional Data Modeling, Star Schema Modeling, snowflake schema Modeling and good understanding about Fact and Dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Thorough understanding of Kimball’s’ theory, KPIs, SQL Architecture.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes
• Good Knowledge and understanding on the SharePoint Server.
• Experience in using Performance Point Server.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Experience in debug, maintenance of ETL packages and ETL optimization using SQL Server best practices.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS:

Database: SQL Server 2000, 2005, 2008, 2008 R2, 2012, Oracle

Operating Systems: Windows XP/2000/2003.

Programming Languages: T- SQL, PL/SQL, MDX, Java

BI Suite: SSAS, SSIS, SSRS, PPS 2007/2010

ETL TOOLS: DTS, SSIS

Database Tools: Sql Profiler, Database Engine Tuning Advisor, SSMS, COSMOS

VC Tools: Visual Source Safe, TFS, SVN.

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL BI Architect/Lead Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Identified and prioritized requirements from stakeholders through brainstorming. Documented and developed an ongoing process of gaining consensus into the requirements process.
• Defined and documented problem definition, scope and project objectives by collaborating with stakeholders.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Designed and worked on DQS and MDS SQL Server 2012 Tools to cleanse and establish master data management from various data sources. The resultant data are then use in the EDW environment dimensions.
• Migrate from SQL Server to Netezza with SSIS
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Experience in writingScopeScripts for daily loading data fromCOSMOSServer and scheduling the data load.
• Designed and developed customized Cognos reports for the client: Impromptu, Power Play Cube, Ad-hoc and Cognos queries using Cognos 7.4 Reporting platform.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Schedule, Monitor and control Access of users by creating groups in Cognos Connection
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• In addition to hands on development experience using coreJava, had an opportunity to develop a prototype B2C e-commerce system using the MVC Framework, JavaBeans, JDBC, JSPs, and Servlets.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema. Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS), Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Provide input in implementing, and maintaining change control and testing processes for modifications to databases.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Data reporting experience with Crystal Reports, SSRS.
• Create, or support creation of required reports in response to business user needs.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Perform database coding and security reviews.
• Created Time Dimensions on OLAP Cubes using SSAS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Involved in preparing test cases for SQL Server 2008 BI Database Testing.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Prepared Test plans for DW Database Testing.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Data development experience with SQL Server Integration Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Designed EIM / Metadata Taxonomy System with Microsoft Data Quality Services (DQS) and Microsoft Master Data Services (MDS) that greatly simplified data asset tracking and reduced storage overhead.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.

Environment: MS SQL Server 2012/2008/2005, T-SQL, SSRS, SSAS, SSIS Packages, SSRS,ETL, Crystal Reports, ODBC, DTS, Erwin, ASP.Net 3.0, Ado.Net 3.0, HTML5, AJAX, C#.Net, Excel, Business, Business Objects Data Integrator 6.5, SharePoint Server, MDX, ProClarity, OLAP, OLTP, DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, Virginia Beach, VA

SQL BI Architect/Lead Developer

Responsibilities:

• Developed new and modified existing SSIS (Sql Server Integration Services) packages to make sure student system data is populated in to the data marts.
• Modified existing SSAS (Sql Server Analysis Services) cubes in the student system data mart.
• Created the hierarchies in the date and time dimensions.
• Created the actions like standard, reporting, calculated members in SSAS as per the requirement.
• Integrated the registry activity and student system cubes into single cube called Student System.
• Loaded tables with reinsurance data coming from different sources like Flat files, Excel files.
• Establish appropriate end-user database access control levels.
• Experience with Web Forms.
• Java Basics, branching and looping, Arrays, Advanced class concepts, Exception handling, Stream I/O, Servlet basics.
• Multi-threading in Java.
• Experienced in EDM / MDM using tools like ER Studio & MS MDS / DQS, Caching Technologies, Data ware housing, BI and ETL
• Worked with Healthcare Payer Operations by overseeing the overall project, with ultimate responsibility for success or failure of the engagement, specifically focused on ensuring overall client satisfaction and quality of delivery and profitability of the engagement.
• Integrated the new system/data called WHOSNEXT into the student system cube.
• Created/Modified the attribute relationships in student system data mart.
• Generated reports for Reinsurance modules like Facultative Reinsurance and Treaty Reinsurance.
• Created Scope scripts and submitted the jobs to Cosmos Server for loading the data for downstream applications.
• SSIS is used to imports of the data, build scheduling of the packages, to define integration flow, log data error exceptions.
• Web Development Experience with ASP.NET 2.0/4.0, HTML5, AJAX.
• Develop routines for end users to facilitate best practices database use.
• Developed scorecard template functionality edit/view/report using ASP.NET, C#, MS SQL, Stored Procedures.
• Involved in migration from Teradata to SQL Server 2008.
• Experience with CSS driven layouts.·
• Did a C#, ASP.Net / VB.Net / SQL Server project converting their existing VB6 desktop application to a web application.
• Monitor system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Created the table scripts for the WHOSNEXT system and loaded the data into it using SSIS.
• Used the XML, Parent Package Variable, Sql Server package configurations in the SSIS packages.
• Existing data from diverse data sources were consolidated into uniform sql server database.
• Database experience with Oracle 11GR2
• Worked with Teradata in creating forms.
• Delivered world class, high quality design and code using the Microsoft .NET Framework. Used agile methodologies including TDD, CI, Refactoring and Code Reviews
• Developed the chart type, tablix, matrix reports in SSRS (Sql Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.
• Plan and coordinate data migrations between systems.
• Used performance Point Services, SSRS, excel as the reporting tools.
• Wrote the expressions in SSRS wherever necessary.
• Used the dashboard designer in the PPS to design the reports.
• Involved in preparing test cases for SQL Server 2008 BI Database Testing.
• Created the dashboard using SSRS from the OLAP system.
• Deployed these reports into the SharePoint after developing the reports.
• Perform overall tuning of the database management system in a large scale environment 5000+ Databases
• Modified the MDX query in the reports wherever necessary as per the requirement.
• Web development experience with C# Dot Net, HTML, CSS
• Crated the views from the PeopleSoft tables and populated the data into the fact and dimension tables using SSIS.
• Participating in the testing of student system data mart, by supporting the end users and resolved program issues uncovered during testing.
• Interacted with the business users to get the requirements on reporting purposes.
• Interacted with the offshore team to discuss the progress of the project.
• Prepared Test plans for DW Database Testing.

Environment: Windows XP, SQL Server 2008 R2, SSAS, SSIS, SSRS, T-SQL, Crystal Reports, MDX, ASP.Net 2.0/4.0, C#, Performance Point Server 2010, OLAP, OLTP, Excel, SVN, SharePoint 2010, HTML5, AJAX, Oracle 11GR2, CSS

Confidential, Cincinnati, OH

T-SQL Server BI Developer (SSIS, SSAS and SSRS)

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Subreports using Sql Server Reporting Services 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle and SQL Server.
• Performed a key developer role in the development of enterprise software solutions encompassing: services and service layer, service integration to UI and data, 3rd party integration, refactoring current applications
• Designed a dimensional model star schema using Microsoft Visio.
• Developed custom reports using SSRS/SQL Server BI studio.
• Trend and perform capacity planning on databases / SQL Instances balancing contingency and long term planning.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Created and occasionally maintained web applications written in ASP.NET (C#) and CSS supported by a database or CMS backend. The split between front-end work (HTML/CSS) and actual coding was roughly 70/30.
• Analyzing database requirements to meet the needs of Enterprise and Business initiatives.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent..
• Perform continuous assessment and recommend to management the appropriate patches to be applied.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Utilized and implemented .NET programming and database best practices and had the ability to quickly understand and implement new APIs and Web Service integration points.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Responsible for conversion of reports from Crystal Reports to SSRS
• Worked with ETL tools such as SQL Server Integration Services.
• Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2008, SSAS, SSIS, T-SQL, SSRS, Crystal Reports, MDX, ASP.NET 3.0, HTML5, AJAX, Windows Server 2003, Oracle 9i,Performance Point Server 2010, Erwin, OLAP, OLTP.

Confidential, Bothell, WA

MS SQLServer BIDeveloper (SSIS/SSRS/SSAS)

Responsibilities:

• Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Respond to and resolve database access and performance issues.
• Building UAT and Test environments using Production back ups.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Proactively monitoring system performance and availability and pinpoint operational bottlenecks to provide corrective action.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Analysis of Requirements for new functionality or extended functionality, sometimes integrating with legacy systems outside of the Database.
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Work with System Engineering and Software Engineering teams to apply patches and cumulative hot fixes to the production environment.
• Involved in migration of SSRS from SQL 2000 to SQL 2005
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005, SSAS, SSIS, T-SQL, SSRS, Crystal Reports, Windows Server 2003, MS Access.

Confidential, Naperville, IL

BI Developer/SQL Server Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PLSQL to create Tables, Views, and Triggers and stored Procedures.
• Worked with Healthcare Payer Operations by reviewing Risks and Risk Action Plan on a regular basis.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Used informatica for ETL process.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Worked with Healthcare Payer Operations by understanding the underlying technologies being used on a project to be able to direct how to design, develop, test, and implement a technical development project
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Generated the various kinds of reports using Graphs and Images.
• Migrated some Crystal reports to SSRS reports
• Created Parameterized reports and linked reports using Bookmark links, Drill through links and Hyperlinks.

Environment: T-SQL, SQL Server 2000, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler.

Confidential

Jr. SQL Server Developer/ DBA

Responsibilities:

• Designed, implemented and administrated SQL Server 2000 databases.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.

Environment: SQL Server 2000 Enterprise Edition, Enterprise Manager, Query Analyzer, Import & Export Data, VB.Net, Windows 2000, MS Access, MS Excel.