SUMMARY:

• Over 8 years of IT experience in Capital Markets Banking / Financials/ Mortgages, Healthcare and Retail sectors as a SQL server Developer that includes Database Design and Development of SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2008 R 2/2012/2014.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2000/20 R 2/2012/2014.
• Expert in providing Enterprise Reporting solutions using SSRS 2000/2005/2008/2008 R2/2012/2014, Crystal Reports, Performance Point Server, ProClarity and SharePoint Services.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Expertise in developing application using.NET, C#, SQL Server.
• Data Modeling - Hands on Data warehousing and Data Modeling tools like Erwin 4.0, Visio 5.0/ 2002.
• Expertise in Oracle 9i/10g database.

TECHNICAL SKILLS:

Operating System: Windows NT/98/2000/XP/2003 server

Languages: Pascal, C++, Visual Basic 6.0. VB.Net, T-SQL, PL/SQL, Visual Studio 2003/2005

Tools: DTS, SSIS,SSRS,SSAS

DATABASE: MS Access, MS SQL Server 7.0/2000/ 2005/2008/2012/2014, Oracle8i/9i

Tools: Utility Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler

Software: MS Office, Visio, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services 2005/2008/2012/2014, Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr SQL Server BI Developer, SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
• Design and create SQL Database, tables, indexes, and views.
• Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Created SQL Server Reports using SSRS 2012.
• Developed Query for generating drill down and drill through reports in SSRS 2012.
• Uploaded reports on to the report manager and organized them in folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages.
• Efficiently implemented Error handling in SSIS
• Created SSIS packages to load data from various data sources Oracle,DB2 and Flat files
• Consolidate the data load into ODS using SSIS
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Involved in writing MDX queries.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.
• Provided day-to-day administration tasks like space and log management.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Configured Snapshot replication for reporting, user acceptance test and development servers.

Environment: Windows 2008 R 2/2008/2012/2014, Integration Services, Analysis Services, Reporting Services, SQL Server Data Tools, Team Foundation Server, ASP.Net.

Confidential, Detroit, MI

SQL BI SSIS/SSRS/SSAS Developer

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Converted data types using Derived Column, Data Conversion Transformation.
• Converted various data files (CSV, XML, COBOL and Legacy Flat Files) based on business logic using Script Task and Script Component.
• Generated 7M Record files using SSIS Script Task and Script component Format the files based on client requested format using.
• Setup the client packages for Accounts, Transactions and Notes based on Templates.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Identified Dimensions and Facts, Used MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.

Environment: SQL Server 2008/2012 Enterprise Edition,SSIS,SSRS,SSAS, Visual Studio 2005, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003 R2.

Confidential, Arlington VA

SQL SSRS/SSIS/SSAS Developer

Responsibilities:

• Used NT Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Responsible for creating Databases, Tables, Clustered/Non-Clustered Indexes, Unique/Check Constraints, Views, Stored Procedures & Triggers.
• Monitor SQL Error Logs/Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Developed packages using SSIS and controlled its execution, by implementing the infrastructure that enables execution order, logging, variables, and event handling.
• Created ETL for data Transfer and Migration.
• Developed custom reports using SSRS/SQL Server BI Studio.
• Created Stepped and Blocked reports using SSRS.
• Created Drill Through and Various Cross tabbed reports using SSRS.
• Build the cubes using SSAS.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.

Environment: SQL Server 2008/2012 Enterprise Edition, Enterprise Manager, ERWIN, UML, MS Project, Windows 2003 Server, .NET, C#, ASP.NET, SSIS, SSRS, SSAS

Confidential, Overland Park, KS

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2008 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation of DTS packages to SSIS packages.
• Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards.

Environment: MS SQL Server 2008, MS Analysis Services, SSIS,SSRS, MS-Excel, DTS, Visual Studio.Net 2003

Confidential, CA

MS SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for testing to optimize the procedures and triggers to be used in production.
• Involved in project planning also schedule for database module with project managers.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Responsible for Day-to-day activities like taking backup (or scheduling the backups daily/weekly/monthly for database or transaction log) on disk and restoring the databases and transaction log on production/development servers as per requirement.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks user counts and connections/locks etc.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Involved in analysis and design of disaster recovery strategies with business managers to meet the business requirements.
• Maintained the database consistency with DBCC at regular intervals.
• Rebuilded the indexes at regular intervals for better performance.
• Designed and implemented the warehouse data model, dimension, fact and summary tables.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Involved in creating Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data using DTS.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Written complex T-SQL queries and Database triggers.
• Created indexes and was involved in Performance Monitoring.
• Wrote various stored procedures for the purpose of application development.

Environment: MS SQL Server 2008, MS Access, MS Excel, TFS, SSIS, SSRS, SSAS, ER-Win v4.0.

Confidential

SQL Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Setup new SQL Server instances.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Performed query optimization and tuning, debugging and maintenance of stored procedures.
• Provided database security by using role base authorization on accessing data.
• Used System tables and stored procedures to retrieve metadata.
• Administered the database using SQL Server Enterprise Manager.
• Performed troubleshooting operations on the production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Developed user friendly GUI using HTML and ASP.NET 1.0/1.1 to display and access data.
• Implemented database programming by using the ADO.NET object Model.

Environment: SQL Server 2008, DTS Package, SQL Server Enterprise Manager, SQL Server Query Analyzer

Confidential

SQL Server Developer/SSIS developer

Responsibilities:

• Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Install, tune, maintain and monitor SQL Server for the Production environment
• Created DTS package to get data from different sources, consolidate and merge into one single source.
• Created variety of reports for business to provide them with critical information about business status.
• Actively involved in Normalization & De-normalization of database.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Involved in System testing.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.

Environment: SQL Server 2005, Access 2000 & Windows 2K platform ADO.NET, MS Project