SUMMARY

• An experienced candidate with 7 years experience in IT with proficiency in application development, testing and implementation of business requirements in MS SQL Server 2008/2005/2000
• Experienced in Banking, Healthcare, Communications sectors
• Comprehensive knowledge of Software Development Life Cycle(SDLC) and implementing the business solutions using MS SQL Server Management Studio and Business Intelligence Development Studio(SSIS,SSAS,SSRS)
• Well acquainted with process of requirement gathering and analyzing Client requirements
• Experience in MS SQ MS - SQL/BI Consultant L Server installation, configuration, performance tuning, client/server connectivity
• Expert knowledge of T-SQL DDL and DML commands, writing Stored Procedures, functions, triggers, performance tuning and optimization of SQL stored procedures, maintenance of data integrity using Constraints (Primary & Foreign Key)
• Skills in developing SSIS packages for data migration, incremental loads and designed the work flow canvas for multiple transformations of data
• Thorough knowledge of features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications.
• Experienced in using multiple Control flow and Data flow tasks and transforms like Conditional Split, Aggregate, Data Conversion, Lookup, Sort, Merge etc. to build complex SSIS Packages
• In depth knowledge of Data Warehouse Architecture (Star and Snowflake schema) and Modeling, Inmon and Ralph Kimball Technologies and thorough understanding of Cubes, their processing and deployment in data warehouse and data mart design using SSAS tool.
• Good understanding of Slowly Changing Dimension Tables, Normalization and Denormalization concepts
• Created complex and sophisticated reports using SSRS for analysis of data at project level
• Experience with Drilldown, Bar, Line Charts using Parameters and writing ad-hoc queries from SQL Server databases as per the requirements for business analysis
• Acquaintance with the practices of importing and exporting Data, Backing Up and Restoring Databases, Managing Servers, Managing Clients, Automating Administrative Tasks.
• Team player and independent worker with excellent communication and presentation skills

TECHNICAL SKILLS

Languages: C, C++, T-SQL

Databases: MS SQL Server 2000,2005,2008 R2

Database Tools: SQL Server Profiler, SQL Server Management Studio, Business Intelligence Development Studio (BIDS),SQL Server Query Analyzer, DTS tools,SSIS, SSRS, SSAS, DTS, Microsoft Visual Studio 2008, Sharepoint Server

Operating Systems: Windows7/Vista/XP/2003/2000, NT&Windows 9x and MS-DOS Other Software Microsoft Office applications, Matlab, PSPice, Sigmaplot, Image J, Insight Tool Kit (ITK) Packages

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Responsibilities:

• Improved job performance by modifying stored procedure and SSIS package to view necessary data in SSRS reports
• Integrated data from other application into current cubes by modifying views, stored procedures and SSIS packages
• Executed deliverables as per Change Control Procedure and brought about system/data change in the application
• Provided support within timeline guided by Service Level Agreement(SLA)
• Resolved and tracked trouble tickets by debugging underlying issue through Action Request System.
• Performed formal manual system manual testing, reviewing in HP Quality Centre for SP3 upgrade, Windows 7
• Modified security controls on Sharepoint, databases with Data Steward Utility
• Debugged ETL packages dealing with different data sources in case of nightly job failures using logs.
• Scheduled and monitored SQL Server Agent Jobs to run various SSIS packages loading data from external application.
• Worked with Data Quality Analysis System to monitor the type of incoming data meeting the desired design and architecture
• Maintained and updated validation documents as per the protocol.
• Improved the performance of a stored procedure implementing temporary to fixed table, modifying the destination table, eliminating unnecessary sorting and using optimized queries.
• Integrated production processes into a system that provides visibility of status to the entire organization
• Played instrumental role in procuring Quality approval for a system/data movement into production
• Developed Drill down, drill through and charts reports with SSRS R2 on top of a relational database

Environment: MS SSIS, SSRS, SSAS in Business Intelligence Development Studio, SQL Server 2005/2008, Remedy Action Request System, Windows XP, Windows Server 2003, Windows Server 2008, Sharepoint Server

Confidential, Westchester, IL

BI Developer

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and performed different kinds of transformations using SSIS.
• Using Data Transformation Services (DTS) to populate data from various data sources using the concept of OLE DB.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Logging.
• Scheduled and monitored SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio to automate manual tasks.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Performed various Data Transformations using conditional split, data conversion, derived columns and lookups to source data to transfer data in a format as per organization needs.
• Improved the performance of SSIS packages by implementing parallel execution, removing unnecessary sorting and using optimized queries.
• Integrated production processes into a system that provides visibility of status to the entire organization
• Created SSIS Packages to perform filtering operations and automated it to import the data on daily basis from the sources to SQL Server to load the data
• Built SSAS Cubes and developed KPIs, Calculated members for business analysis and created partitions, designed aggregations
• Developed Drill down, drill through and charts reports with SSRS R2 on top of a relational database and also SSAS Cubes.
• Integrated with SharePoint while deploying SSRS Reports.

Environment: MS SSIS, SSRS, SSAS in Business Intelligence Development Studio, SQL Server 2005/2008, ProClarity, Windows XP, Windows Server 2003, Windows Server 2008, Performance profiler, Sharepoint Sever

Confidential, Herndon, VA

SQL Developer

Responsibilities:

• Designed and created new Database objects for implementing complex SQL tasks to meet business criteria
• Developed SSAS Cubes on selected data sources with multiple calculated members for generating reports
• Deployed Major reports and SSAS KPIs onto the organization’s SharePoint Server
• Extensively worked on managing ETL process by pulling large volume of data from OLTP to a staging Database using SSIS for data transformation.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• Designed various XML Configuration files to make SSIS packages dynamic with respect to the variables being passed and also to deploy them.
• Implemented Lookup, Conditional Split and Derived Column, Merge Join, Aggregate tasks while loading Data from Staging to a Data Ware House.
• Involved in Building a data-warehouse with Dimensions and Fact Tables based on the Business requirements.
• Implemented Different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
• Generated KPIs with different Measures and Calculated Members by applying business conditions.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Performed optimization of the cube by creating attribute hierarchies, Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.

Environment: MS Access, T-SQL,MS SQL 2000, 2005, 2008, SQL Server Analysis Services(SSAS), SharePoint, Query Analyzer

Confidential, GA - Alpharetta

SQL Server Developer

Responsibilities:

• Co-ordinated with the functional team to gather requirements from business department for designing various types of reports as per the needs.
• Met the information demands of our business department by delivering timely, accurate, meaningful and standardized data and reporting.
• Generated query Parameters and Report Parameters to control data returned by the query and filter data at report level using SSRS
• Imported data sets from various format sources like Text files, Excel files, HTML XML Files to generate reports
• Developed various types of complex reports like Drill Down, Drill through reports, Pie Charts, Line Charts using SSRS 2005/2008
• Designed a Dynamic Report Menu, which is specific to the business user browsing the report on the Company’s report server using a back-end model on SQL Database Engine.
• Implemented complex SQL queries, stored procedures, triggers, views, constraints, joins, DDL, DML and user defined functions to implement the business logic
• Created Indexes on columns required to speed up queries in SQL Server Management Studio.
• Run Import/Export wizard to provide CSV and Excel files to managers for the particular records they want for different meetings.
• Involved in assisting DBA to trace the database objects in SQL Profiler for Performance Tuning on stored procedures and indexes.
• Executed Error Handling in Stored Procedures with Try-Catch blocks to maintain a log of errors.
• Documented rules on database design, objects security, performance optimization and project testing and specifications

Environment: MS SSIS, SSRS, SSAS, MS Visio, TSQL in Management Studio 2005/2008, Windows XP, Windows Server 2003, Windows Server 2008, MS PPS 2007, MS Visual Source Safe, MS Office 2007, Performance Profiler

Confidential, OH

SQL Database Developer

Responsibilities:

• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Implemented SSIS packages containing SQL tasks for sending emails or fax if the requirement is met
• Performed analysis of Confidential t data using Conditional Spilt, derived columns, data transformations
• Updated and maintained Confidential t data regularly by implementing incremental load packages
• Performed deployment of SSIS packages and setting up SQL server agent tasks for daily update of the Confidential t data
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created Event Handlers and performed Error Handling in SSIS packages in case of fault in case of faulty data
• Incorporated Dynamic Checkpoints to facilitate rerunning of a package from the point of failure.
• Completed database logging, error logging and configuration files were taken care of in all the development, QA and Production environments.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures and performed optimization by understanding execution plan

Environment: MS SSIS in Business Intelligence Studio, SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Windows XP, Windows Server 2003,2008,MS Office 2007

Confidential, Falls Church, VA

SQL developer Data Analysis/Profiling

Responsibilities:

• Used SQL Profiler and Database Tuning Advisor for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers and also created SQL scripts for tuning and scheduling.
• Involved in Error Handling using Try/catch Block
• Wrote SQL scripts for performing data profiling like cardinalities, primary keys, business rules that incorporated in the database)
• Developed writing advanced SQL queries, stored procedures, understood and build constraints on the data as per the relations
• Used Temp tables, CTEs and Table-Valued Functions to filter out records from source systems based on the business rules.
• Acquainted with different storage modes in Analysis Services such as MOLAP, ROLAP and HOLAP.
• Built and processed cubes(full, incremental, structure),designed and created partitions, built aggregations on the cubes
• Maintained hierarchy of the attributes as per the requirements and built KPIs for understanding business parameters
• Generated Drill down and Drill through reports from the cache containing aggregated data
• Worked on designing Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.

Environment: MS-SQL Server Management Studio 2005, 2008, Business Intelligence Studio(SSAS, SSRS), SQL Profiler, Query Analyzer, Windows XP, Windows Server 2003,2008,MS Office 2007

Confidential

Assistant Developer

Responsibilities:

• Provided data to Retail Marketing team for launching different campaigns for cross-sell, product promotional campaign, monitoring performance of the already launched campaign by executing basic DDL and DML commands SQL queries
• Prepared a generalized Drill down, Tabular reports of product holding to be used by analytics team for customer profiling and generating leads for cross sell of liabilities product/ asset product.
• Developed basic to intermediate query writing skills to retrieve and update Customer Information.
• Developed the basic concept of Stored Procedures, views, triggers, joins, user defined functions
• Developed simple Stored-Procedures with multiple input/output parameters, Pre-defined Functions, Aggregations and Data filters.
• Developed simple to complex joins to retrieve data from multiple tables with Referential Integrity.
• Made triggers on tables with error messages to ensure data consistency during data entry.
• Developed knowledge of Performance Tuning techniques and SQL Profiler to optimize the query processing time
• Got acquainted with Backup files concept, checking Agent Jobs and Maintenance plans.

Environment: MS-SQL Server 2005, Management Studio, SQL Server Reporting Services(SSRS), Performance profiler, query analyzer, Windows XP, Windows Server 2003,2008,MS Office 2007