SUMMARY

• Over Six Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Server, Oracle, Visual Studio 2005/2008, C#, .NET framework, OOPS Concepts.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Experience in Software Analysis, Design, Development, Testing, Implementation and Production, support of Client/Server and Web based applications.
• Experienced in RDBMS concepts, Creating Databases, DDL/DML Triggers, constructing normalized and de - normalized tables, user defined functions, complex and dynamic stored procedures, views, synonyms, cursors and Indexes.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Experience in Optimizing the Database by creating various Clustered and Non-Clustered Indexes.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Good Knowledge on Error handling, Performing Incremental Loads and Logging Operations using SSIS.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Knowledge of Server Components using .NET Framework and Visual Studio 2005.
• Created Parameterized reports, Sub reports and thorough knowledge of reporting server architecture. (Table, chart and matrix reports).
• Highly motivated and adaptive with the ability to grasp things quickly and posess excellent interpersonal, technical and communicational skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

Languages: T-SQL, SQL, Dynamic SQL, .NET Framework, C, C++, C#, ASP.NET, VBScript, XML, HTML, DHTML, HTTP.

RDBMS: SQL Server 2008/2005/2000 , Oracle 11g/10g/9i/8i and MS Access 2003/2000/97

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

Tools: & 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, Web Services, SOAP.

Operating Systems: Unix, Windows NT/XP/2003/2000,Windows 9x and MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, St. Peters, MO

SQL Server BI Developer/Analyst

Responsibilities:

• Gathered business requirements from users and translated them as technical specification for development.
• Identified various data sources, formulated data dictionaries, design and develop data models based on the given specs and requirements.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS.
• Migrated Crystal reports to SSRS 2008.
• Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Migration of stored procedures and database objects between development and test environments.
• Author concise functional/technical documentation and provide status and project updates using Visual Studio Team Foundation Server.
• Attend regular project meetings and weekly status meeting

Environment: SQL Server 2008/2008R2 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003, Team Foundation Server, Visual Studio 2010 Ultimate (TFS).

Confidential, Columbia, MD

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Developed dashboard reports to populate data using SSRS
• Involved in automaton of payment history
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Involved in SSIS/DTS packages
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Created pages in the reports to display depend on Prompt values.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files and xml.
• Developed Query for generating drill down reports in SSRS 2008 and Crystal Reports 9.0.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Involved in accounting code module to populate general ledger code by writing complex T-SQL queries, stored procedures.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: SQL Server 2008, DTS, SSIS, SSRS, Microsoft Visual Studio 2005, SQL Server OLAP 2005, Reporting Services 2005, T-SQL, MS Access, Windows 2003 Server.

Confidential, Detroit, MI

SQL Server BI Developer

Responsibilities:

• Designed, coded, tested and implementedstored procedures and functionsfor new and existing softwareapplication requirements.
• Proficiency in Transact-SQL, stored procedures and writing efficient code in an OLTP and OLAP environment.
• Defined and developed data migration strategy between different sources and platforms using DTS and SSIS Platform.
• Scheduling Jobs on various stored procedures and packages.
• Login and User Management: Worked on authentication by Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.
• Created custom reports, matrix reports, drill down reports and reports with graphs.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000 Enterprise Edition, Enterprise Manager, ER-Studio, UML, MS Project, Windows 2003 Server, .NET.

Confidential, Bridgewater, NJ

SQL Server Developer

Responsibilities:

• Involved in gather user requirements and system specifications.
• Developed stored procedures, functions and database triggers.
• Maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest service packs.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel spreadsheet to SQL Server 2005.
• Migrated DTS packages to SSIS packages by modifying those packages.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2005 to achieve the efficiency of SSAS.
• Build MDX queries and data mining expression (DMX) queries for Analysis Services and Reporting Services.
• Experience in creating multiple reports (SSRS) in Drill mode using tables, cross tabs and charts.
• Design, deployment and maintenance of various SSRS in SQL Server 2005.
• Designed and implemented parameterized and cascading parameterized reports using SSRS and Crystal Reports with .NET applications.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Involved in developing logical and physical model of database using Erwin.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2005, SQL Server Business Intelligence Development Studio 2008/2005, Procalrity, MS Access, MySQL, Postgre SQL, DTS to Import & Export Data, VB Script, Windows XP.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler.