SUMMARY

• Over 7 years of experience with design, development and implementation of SQL Server based Application methodologies in the field of commercial and business applications.
• Experience in installation, Upgrade and configuration of MS SQL Server database.
• Excellent understanding of Relational Database Systems, Normalization and Logical and Physical data modeling.
• Extensive knowledge in T - SQL queries (DDL and DML) and construction of complex queries involving multiple tables to create and maintain database objects like Stored Procedures, User Defined Functions, Triggers, Views, Indexes.
• Expertise in Performance Tuning and Query Optimization.
• Experience in building Workflow solutions, Data integration and Extract, Transform and Load (ETL) Solutions for Data warehousing using DTS/SSIS packages from multiple sources like Tera-Data, DB2, Oracle, MS Access, Flat files, SQL Server etc., and loading them into Confidential databases.
• Have expertise in migrating from MS SQL Server and Converting DTS packages to SSIS packages.
• Experience in maintaining Error Logging using Exceptional Handling in T-SQL and MS SQL Server Integration Services (SSIS).
• Hands on experience in Scheduling Jobs and Alerts in MS SQL Server Integration Services (SSIS).
• Have good experience in developing Parameterized Reports, Drill down Reports and Drill through Reports.
• Experience in developing User Reports and Management Reports using MS SQL Server Reporting Services (SSRS).
• Good knowledge in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Good Understanding in Dimensional Modeling, ER Modeling, Star Schema and Snow Flake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience in developing OLAP Cubes using SSAS.
• Hands on experience in creating Data Source Views with Added Measures, Dimensions, Calculations and Actions in SSAS.
• Expert in analyzing the Shared Dimension Tables, Hierarchies, Levels, Cube Partitions and Aggregations on MS OLAP/ Analysis Server (SSAS) accordingly.
• Expert level experience in Configuring, Managing and Troubleshooting SQL Server 2005/2008.
• Hands on experience in using tools like Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Excellent Communication and Interpersonal skills and strong ability and experience in seeking solutions effectively and aggressively in challenging environments.

TECHNICAL SKILLS

Operating Systems: Windows NT/98/2000/XP, Windows 2003 Server, UNIX

Languages: C, C#.Net, VB.Net, XML, HTML, T-SQL, PL/SQL

Databases: MS SQL Server 2000/05/08, Oracle 9i/10g, MS Access, DB2

ETL Tools: DTS, SSIS (SQL Server Integration Services)

Tools: /Utilities: Enterprise Manager, SSMS (SQL Server Management Studio)Business Intelligence Development Studio (BIDS), DTA, SSASSQL Profiler, Visio, Microsoft Office, MsVisio2003/2007

Reporting Services: SQL Server Reporting Services (SSRS), Crystal Reports 2008

PROFESSIONAL EXPERIENCE

Confidential, Plantation, Florida

SQL Server/BI Developer

Responsibilities:

• Created packages to migrate data from different data sources to data warehouse.
• Experience in maintaining Error Logging using Exceptional Handling and MS SQL Server Integration Services (SSIS).
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• CreatedSSISpackages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validate
• Experience in creating master and child packages, package configurations and logging.
• Excellent knowledge of using variables and expressions in packages.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Created report model for Ad-hoc reporting, generate report in XML format.
• Developed complex stored procedures usingT-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Job scheduling and alerts.
• Optimized the performance of various SQL scripts, stored procedures and triggers
• Used Crystal Reports to export specific data into an excel spreadsheet.
• Created sub reports and crosstab reports.
• Passing of parameters from main report to the sub report.
• Defined sections and subsections for the reports.
• Developed search queries and strings to filter and sort the data from centralized server.
• Responsible to support the issues with reports on the crystal enterprise environments ( Development, UAT, Test and Production )

Environment: MS SQL Server 2000/2008, SSIS 2008, SSRS, MS Office, Crystal Reports 2008, Visual Studio.

Confidential, Denver, CO

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Actively participated in Gathering User Requirement and Functional Specification
• Created SQL server objects like Indexes, Indexed Views, Stored Procedures (dynamic and static), effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data to data warehouse databases and involved in Data cleansing in the data transfer
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling
• Worked on Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS), BCP (bulk copy program) and FTP task in SSIS.
• Developed Query for generating Drill Down and Drill Through reports in SSRS 2008
• Generated Tabular, Sub reports and Parameterized reports for the Business users
• Formatted the reports using the Global variables and expressions
• Designed report models based on users requirements, explain and train users to use report builder to generate their own personalized reports.
• Involved in Performance Tuning to improve response time of Stored Procedures.
• Maintained Database Backups and Scheduled Jobs and Alerts involving with Administrator

Environment: MS SQL Server 2000/2008, T-SQL, SSIS 2008, SSRS 2008, SSAS, SQL Server BIDS, MS- Visual Studio 2008, ADO.Net, XML, MsVisio2003/2007

Confidential, Minneapolis, MN

SQL Server /SSRS/SSAS Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005/08 with latest Service Packs.
• Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Developed and maintained enterprise reporting (SSRS Reporting Services) based on specifications and business needs and modified existing reports as needed.
• Developed ETL’s using transformations like OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, Slowly Changing Dimension, Union All, Script Task, Flat file Source, Flat file Destination, Conditional Split.
• Developed Event Handlers for executing Stored Procedures and storing the rows Inserted, rows Selected, rows Rejected, rows Updated and rows Unchanged in appropriate SQL Tables.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Creating package dependencies by calling Child packages within Parent.
• Using Configurations to make dynamic changes to packages. Configurations like XML, SQL Server and Environment Variables have been used.
• Designed, administrated and developed Star Schema Data marts
• Designed and created OLAP cubes defining the dimensions and relationship between dimensions and measure groups
• Experience in creating multiple reports (SSRS) in Drill mode using tables, crosses tabs and charts.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: SQL Server 2005/08, SSRS, SSAS, Visual Studio,, MsVisio2003/2007

Confidential, Houston, TX

SQL Server SSIS/SSRS Developer

Responsibilities:

• Created new database objects likeTables, User Defined Functions, Triggers, Procedures, Functions, IndexesandViews, SQL joins and statements as per the developer team’s request through team tracks.
• Involved in data cleansing to facilitate efficient data transfer between various environments.
• Analyzed performance related queries and tune the same using SQL Query Analyzer to optimize application and system performance.
• Worked on Extraction, Transforming and Loading (ETL) data flows using SSIS and created mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation and Slowly Changing Dimension.
• Created SSIS Packages using SSIS Designer for export heterogeneous data, Excel Spreadsheet to SQL Server 2005.
• Create Reports using SQL Server Reporting Services (SSRS) and analyzed using Server Analysis Services (SSAS).
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through and Sub Reports

Environment: SQL Server 2005/08, SSIS, SSRS, Visual Studio

Confidential

Programmer/SQL Developer

Responsibilities:

• Creation, manipulation and supporting the SQL Server databases.
• Involved in the Data modeling, Physical and Logical Design of Database
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Stored procedures and triggers were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Configured Exchange Server for sending automatic mails to the respective people when a jobfailed or succeed
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to SQL Server using DTS and also used BCP and Bulk Insert and even the other way
• Created documentation as required.
• Performance tuning, and optimization of procedures and queries.
• Responsible for the creation and maintenance of entity relationship diagrams
• Conducted data import and export operations using the DTS wizard
• Responsible for testing, to optimize the procedures and triggers to be used in production.
• Created backups for databases and involved in Performance tuning.
• Maintain the application as per the user requirement.

Environment: MS SQL Server 7.0/2000, Windows 2000/NT/XP, DTS, T-SQL, Query Analyzer, SQL Profiler

Confidential

SQL Developer/ SSRS/SSAS Developer

Responsibilities:

• Installed and configured SQL Server 2000.
• Designed dynamic DTS packages to transfer data between servers, load data into database and achieved data file from different DBMS.
• Created and developed stored procedure, Triggers, functions to handle complex business rules.
• Developed DTS packages to pull data from data sources.
• Developed packages to extract and cleanse the data.
• Involved in developing different reports in SSRS.
• Involved in scheduling and monitoring all maintenance activities.
• Involved in database consistency checks and index fragmentation.
• Involved in tuning system stored procedures for better performance.
• Involved in generating reports from scratch using SQL Server Reporting services.
• Involved in implementing high availability strategies.
• Worked with development teams in the design of physical database and in modification.
• Created clustered and non-clustered indexes.
• Involved in tuning of stored procedures for better performance.

Environment: Windows 2003 server, SQL Server 2000, T-SQL, Reporting services, DTS, MS Access, MS Excel.