PROFESSIONAL EXPERIENCE:

• 7+ years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008R2/2012.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principals.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server .net- Stored Procedures, Triggers, User-defined Functions and Views, Cursors
• Performance tuning of Stored Procedures and T-SQL Queries
• Implementing SQL Server Indexing and Query optimization using Indexes
• Good exposure or knowledge working on C#, VB.NET framework
• Logical & Physical Data modeling, data architecture designs etc.
• Understanding existing data models, data flows and data dictionaries
• Creating new data models, data flows and data dictionaries
• Normalization and De-Normalization techniques
• Involved in Backing up databases and refreshing Data across environments
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Creating data load and Upgrade scripts for data migrations, data formatting and data validations
• Implementing all high availability techniques like clustering, log shipping, replication
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Used ProClarity tool to analyze teh data in teh cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Generated reports from Analysis Services cube by using ProClarity tool.
• TEMPHas very strong background in a disciplined software development life cycle (SDLC) process and TEMPhas excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined wif self-motivation, initiative and teh ability to think outside teh box.
• Expertise in defining teh business process flow and gathering business requirements.
• Strong experience in teh Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed wif project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working wif relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for teh data warehouse to develop teh code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of teh ETL processes using UNIX shell scripting.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C, C++, C#,ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2012,2008R2,2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball &Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer.

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to teh database and written functions, stored procedures and triggers.
• DDL Scripts for generating Tables, Views, Functions.
• Copied Facet State to XML file using T-SQL.
• Analyzed and designed software and database solutions.
• Managed SQL Server environments, by configuring a facet in one instance of SQL Server, copy teh state of teh facet to a file, and tan import that file into another instance of SQL Serveras a policy.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Use to update teh database properties directly by getting into facets.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Created SSIS/DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Designed ETL packages dealing wif different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Configured Reporting Services in SQL Server 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per teh client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2008. Create Calculate member in MOLAP cube using MDX in SSAS 2008.
• Experience in Designing, Building teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Worked on pre-defined facets included by SQL SERVER
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Interacting wif teh users and troubleshooting teh problems involved wif teh development of stored Procedures, triggers and problems related to teh privileges.
• Created Views to reduce database complexities for teh end users.
• Conceive and direct Active Server Page(ASP) initiative to create a web-based dynamic product registration and tracking system linked through ODBC to corporate DBMS.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created checks and constraints to maintain data integrity.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
• Resolved significant PPS connection string issues wif import process.
• Provided DBA assistance in Sharepoint 2007 to Sharepoint 2010 conversion.
• Worked wif Business Analysts, Developers and customers to resolve and escalate project issues.
• Gatheird teh business system requirements and act as a SME for teh system and business and created status reports.
• Worked closely wif teh team in meeting teh deadlines pertaining to design and development deliverables.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/2008/2012, TSQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.

Confidential, Columbia, MD

SQL Server SSIS/SSRS Developer

Responsibilities:

• Optimized teh performance of queries wif modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into teh database.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading wif error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in teh SSIS packages and SQL scripts.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting teh business standards using Fuzzy /exact lookups using SSIS tasks.
• Data management and data processing solutions using SSIS, dis includes Error Handling and Slowly Changing Dimensions.
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between teh databases.
• Extensively used Joins and Common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per teh client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced teh functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2008 Analysis Services(SSAS).
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Migrated and resolved conversion errors for Performance Point Server reports to Sharepoint 2010 Business Intelligence platform.
• Repaired/recreated PPS reports damaged in teh conversion process.
• Worked on Filtered Views, views and Base table integration between different Source systems.
• Used Visual Studio 2008 as Source Control, to maintain drop location to test, all docs and scripts.
• Scheduled teh Packages in SQL Server Agent on daily/weekly/monthly basis.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Interacted wif vendors, developers and customers to manage teh business requirements.
• Verified business requirements and functional specifications.

Environment: Windows2003 Advanced Server, ODBC, MS SQL Server 2005/2008/2012, TSQL, Visual Studio 2008,Oracle, SSRS, SSIS, Erwin.

Confidential, Houston, TX

SQL/MSBI Developer

Responsibilities:

• Managed teh migration of SQL Server 2000 databases to SQL Server 2005
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Generated periodic reports based on teh statistical analysis of teh data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Migrated all DTS packages to SQLServer Integration Services (SSIS) and modified teh package according to teh advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQLServerdatabases using SQLServerIntegration Services (SSIS) to overcome transformation constraints.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Involved in teh Data modeling, Physical Design of Database using tools like Erwin.
• Used DBCC Statements to perform maintenance tasks on teh database. Executed DBCC commands like CHECKDB before backing up teh databases.
• Performing Replication (snapshot and transactional).
• Experience in Designing, Building teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced teh functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQLServer 2005 Analysis Services.
• Created complex SSAS cubes wif multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring teh performance of SQL Server databases.
• Configured replication servers and transactional replication between production & standby server for disaster recovery
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting teh privileges to users and Groups and maintaining security up to date.

Environment: SQL Server 2000/2005, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), DTS, Oracle 9i/8i, T-SQL, MDX, Windows 95/NT/2000/2003, XML, MS Excel and MS Access.

Confidential

MS SQL Server Developer

Responsibilities:

• Extensive working experience in:
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server - Stored Procedures, Triggers, User-defined Functions and Views, Cursors
• Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
• Createdpartition tablefor very large database for good performance.
• Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS
• DeployedSSISpackages and Reports to Production Servers.
• Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool inSSIS.
• Maintained system monitoring jobs and providehigh availability support.
• Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
• ParticipatedDatabases Architectureanddata modelingdesign.
• Performing DBA functions, installing, configuring and supporting database systems.
• Reported all events and requirements through established reporting mechanisms inSSRS.
• Reviewed and developeddata models and database designswif development teams
• Wrotestore proceduresfor some job automations.
• Generated test data andtested databaseto meet teh functionalities deliverables in teh project documentation and specifications.
• Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
• Designed and developedMS SQL ServerReporting Services(SSRS)under SQL Server 2005

Environment:MS SQL Server 2005, SSRS, SSIS, SSAS, ProClarity,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential

SQL Server Developer

Responsibilities:

• Interacted wif Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of teh system
• Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into teh database.
• Implemented Exceptional Handling
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating teh regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS wor