PROFESSIONAL SUMMARY:

• Over seven years of extensive Experience in database Analysis, Design, Development and Database Administration in SQL Server 2008/2005/2000 in Various SDLC environments.
• Hands on experience in MS SQL Server 2008/2005/2000 development in OLTP and data warehousing systems (OLTP/OLAP/ETL)
• Extensive ETL, Analysis and Reporting experience using various technologies (DTS/SSIS/SSRS/PPS from Confidential ) and Impromptu, Cognos 8x/7 series (from Cognos)
• Worked with diversified Industry domains like Telecommunications, Banking, HealthCare, Insurance, and Retail and Energy sectors.
• Involved in Data Modeling, Database Design using Erwin 7.0/6.5 and UML 2.5/2.0/1.5/1.4 tools.
• Worked on database development in SQL Server 2008/2005/2000 using SQL/T - SQL, Stored Procedures, joins, pre-defined and user defined Functions, pre-defined and user defined data types.
• Worked on ETL processes and procedures using DTS/SSIS from heterogeneous data sources like Oracle, Sybase, Interbase, Flat files and other ODBC data sources
• Worked on SQL Server Analysis services for building and deploying Cubes, Process full and incremental loads on daily basis
• Involved in developing, deploying and support of SSRS Reports using SSRS 2005/2008
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation using Water fall model and Agile methodology.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS).
• Proven knowledge of enterprise Reporting and Business Intelligence.
• Experience in designing complex reports including sub reports, parametric, drill down, drill through, cascading and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Experience in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2000/2005/2008.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS Packages.
• Designed and developed OLAP Cubes and Dimensions using SSAS
• Hands on experience with designing, creating, deploying cubes, dimensions, facts, aggregations, various complex calculations, KPI’s and Scorecards using SQL Server Analysis Services (SSAS).
• Well versed in Using MDX (Multi Dimensional Expressions) Queries to retrieve data from Multi dimensional SSAS Cubes.
• Generated Crystal Reports, MS Data Reports using different Reporting tools.
• Hands on experience in Latest Cognos suite BI products including Cognos 8x/7 series.
• Extensive Experience in off shore Coordination.
• Strong skills in Performance Tuning, Query Optimization, Client/Server Connectivity and perform Database Consistency Checks to amplify efficiency of SQL Server 2008/2005/2000.
• Designed and implemented comprehensive Backup plan, disaster recovery strategies and Scheduled Replication process for updating SQL servers 2008/2005/2000.
• Excellent team player and efficient in handling multiple project priorities with outstanding communication, presentation, interpersonal skills and A+ work ethics.

TECHNICAL SKILLS:

Databases: MS SQL Server 2008/2005/2000/7.0, Oracle 10g/9i/8i, My SQL 5.0/4.1 MS - Access 12.0/11.0/10.0/9.0,DB2

Database Tools: Enterprise Manager, Query Analyzer, SSMS, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Database Engine Tuning Advisor, SQL Server Dashboard, Business Intelligence Development Studio (BIDS)0

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9/8.5, Cognos 8x/7 versions, Cognos 8 Go Office.

Data Modeling: Fact and Dimensional Data Modeling, UML, Logical data modeling and Physical data modeling

ETL Tools: SQL Server Integration Services (SSIS), Informatica 7.1,IBM Data Stage 7.5

Languages: C, C++, C#.net, Asp.net T-SQL, PL/SQL,MDX, HTML, DHTML, XML

Operating System: Windows XP/2000/NT/98/95, Vista, Unix, Windows Server 2003/NT

Designing Tools: Erwin 7.0/6.5, Rational Rose, MS Visio

Applications: Light Speed 2005, MS-Office, MS-Project

PROFESSIONAL EXPERIENCE

Confidential

BI Developer

Responsibilities:

• Collaborated along with end users in developing new specifications which provides dynamic functionalities for PAi’s Marketing, Research and Sales Groups.
• Implemented Business Logics using Extensive T-SQL Programming in SQL Server 2005/2008 Environments.
• Extensive coding of T-SQL Stored Procedures, Functions, Views, triggers and dmls.
• Coding of detailed data validation Procedures which combined legacy and YBR (New System) sources.
• Developed Complex ETL solutions using SQL Server Integration Services (SSIS) 2008 to meet Data Flow Requirements.
• Used Complex SSIS Data flow Transformations like Cache,Script, Lookups, Fuzzy Lookup, Merge, Conditional Split, Data Conversion etc.,
• Used Error Handling and Logging features in SSIS to capture and analyze data in developed ETL Solutions.
• Developed Parameterized MDX Queries from SQL Server Analysis Services SSAS Cube.
• Developed Reports by Extracting data from SSAS Cube.
• Developed Reports using SQL Server Reporting Services (SSRS) 2005/2008 from OLTP and OLAP Data sources.
• Developed Drilldown, Drill Through, Parametric and Linked Reports.
• Deployed and Scheduled Reports SSRS Reports to generate Weekly, Monthly reports including Current Status.
• Developed Dashboard and Scorecards using Dundas Charts.

Environment: SQL Server 2008/2005,T-SQL, SQL Profiler, Visual Basic 2008/2005, Dundas Chart Reporting 6.0, TFS(Team Foundation Server), ERWin 7.3.3 Data modeler, Rally, SQL Refactor .

Confidential, Omaha

SQL/SSIS Developer

Responsibilities:

• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options
• Extensive Transact-SQL Programming like developing complex SQL Stored Procedures, Common Table Expressions (CTE’s),Sub Queries, Views, Triggers, User Defined functions in SQL Server 2005/2008 environment.
• Maintaining Complex T-SQL Scripts, Indexes and Complex Queries for Data analysis and for the purpose of extraction and integration (ETL) into a New System.
• Identifying Data discrepancies and providing recommendations for optimal performance.
• Developed complex Extract, Transform and Load(ETL) Solutions using SSIS (SQL Server Integration Services) 2008
• Used Advanced SSIS features like Script task, Lookups, Fuzzy Lookup, Cache Connection Manager and Expressions.
• Used Error Handling and Logging features in SSIS to capture and analyze data in developed ETL Solutions.
• Scheduled SSIS packages using SQL Server Agent for Corresponding Job Tasks.
• Provided Detailed Documentation and Technical specifications for peers and End users during hands off phase

Environment: SQL Server 2008/2005,T-SQL, SQL Profiler, Visual Basic 2008, TFS(Team Foundation Server), ERWin 7.3.3 Data modeler, Agile and Scrum.

Confidential, Las Vegas

BI Developer (SSIS, SSAS, SSRS)

Responsibilities:

• Gathering End User Requirements and translating into Database Specifications and data dictionaries.
• Extensive T-SQL Programming in SQL Server 2008/2005 environments.
• Developed T-SQL Stored Procedures, Sub-Queries, CTE’s, Views, Triggers, User-defined functions for data Extraction and Loading into Enterprise Data warehouse.
• Developed SSIS Packages to Extract and Transform the data from Heterogeneous Source systems and eventually load into EDW.
• Extensive Logging and Error handling in SSIS in various ETL solutions for optimal monitoring of data flow.
• Scheduling ETL Packages Using SQL Server Agent for Periodical, full and Incremental Load of EDW.
• Developed Numerous Ad-hoc and Custom Reports using SQL Server Reporting Services (SSRS) 2008.
• Developed Drill down, Drill through, Cascading, Parametric reports in SSRS 2008.
• Built Multi dimensional Cubes using SQL Server Analysis Services (SSAS) 2008 from existing Dimension and Fact Tables.
• Developing complex Multi Dimensional Expressions (MDX) for analyzing and extracting data from SSAS Cubes in developing reports.
• Involved in Extensive Unit Testing of SQL’s and Stored Procedures and Report any bugs for the same on team track.
• Involved in Performance Tuning of Stored Procedures which included Creating Indexes, Work Around for Expensive Operators, and implementation of various coding standards(Index hints, Locking hints) etc.
• Extensive off Shore coordination with teams in India and Australia.
• Creating Tech Specs (Technical Specifications) For down Stream End User Training during Hands off Phase.

Environment: SQL Server 2008/2005, T-SQL, SSIS, SSAS, SSRS, SQL Profiler, ERwin 7.3.0 Data Modeler, Tortoise SVN, Team Track, Agile and Scrum Methodologies, Microstratergy.

Confidential, Seattle

SQL Server Developer

Responsibilities:

• Gathering End User Requirements and translating into Database Specifications and data dictionaries.
• Extensive T-SQL Programming involving Development of Stored Procedures, CTE’s (Common Table Expressions), Views,Triggers,UserDefinedFunctions and Scalar Functions.
• Involved in Extensive Unit Testing of SQL’s and Stored Procedures and Report any bugs for the same on TFS (Team Foundation Server).
• Involved in Performance Tuning of Stored Procedures which included Creating Indexes, Work Around for Expensive Operators, and implementation of various coding standards(Index hints, Locking hints) etc.
• Trained on Confidential ’s Own internal Data Transformation Tool called METaL (Metadata Extraction, Transformation and Load).
• Installed METaL version 3.1 on Several Internal Servers using Octopus.
• Created numerous SSIS Packages using METaL like ‘Execute SQL Task’, Merge Extract, Precedence and Custom Tasks.
• Scheduling METaL system Packages Using SQL Server Agent.
• Use of Data Vault concepts involving third normalization and Star Schema in Designing Databases.
• Implementing the Concept of Satellites, Links and Hubs from Data Vault in Designing Databases.
• Extensive Use of ERwin Data Modeling version 7.3.2 \ 7.3.0.
• Created Script Templates, Tables Columns, and Constraints using ERwin and forward engineered across various SQL Database environments.
• Unit testing various Adapted Scripts in ERwin on Several similar Models before implementation.
• Creating Tech Specs (Technical Specifications) For down Stream End User Training during Hands off Phase.

Environment: SQL Server 2008, T-SQL, METaL 2.2\3.1, Data Vault, SSIS, SQL Profiler, ERwin 7.3.2\7.3.0 Data Modeler, SQL Query Analyzer, Backup/ Recovery, Octopus 3.2.0, TFS (Team Foundation Server).

Confidential, Atlanta

BI Developer (SSIS, SSAS, SSRS)

Responsibilities:

• Actively involved in complete software development life cycle and designing database schemas in the line of end user’s business Requirements.
• Developed various T-SQL stored procedures, triggers, views, and created/modified tables for data extraction, data load and transformation.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS)
• Worked extensively in designing drill downs, drill through, parameters, Cascading, Conditional formatting reports.
• Developed custom ad-hoc reports using SSRS.
• Created DTS (SSIS) packages to get data from various sources (mainframe, Informix, Oracle).
• Used Error handling and Error logging techniques to capture data in SSIS in various ETL solutions.
• Built Multi dimensional cubes using SSAS involving dimensions and fact tables.
• Involved Analyzing and extracting required data using MDX Expressions from SSAS cubes in developing complex reports. .
• Identified, debugged and resolved database Performance Issues (monitoring and tuning) to ensure optimum database performance using SQL Profiler.
• Involved in Index optimization, Performance, Disk management, Disk partitions and optimizing.
• Worked on locking strategy which is used for various batch Programming structures & Transactions.
• Created BI system documentation and did end user training in the project hand off phase.

Environment: SQL Server 2008,Enterprise Manager, SQL Profiler, Data Model, T-SQL, SQL Query Analyzer, Replication, Backup/ Recovery, DTS/SSIS, Windows 2000/Advanced server.

Confidential, Illinois

SQL Server-SSAS/SSRS developer

Responsibilities:

• Participated in gathering the business requirements and Database Specifications.
• Involved in Data Base Normalization.
• Involved in creating database design to fit new business requirement into SQL Server 2005.
• Developed Tabular, Drilldown, parameterized, Cascaded and sub-reports using SSRS.
• Created numerous reports using Report Studio, Query Studio, analysis Studio in Cognos 8.2 environment.
• Developed Dashboards, Drill Through, Trends Analysis and Metrics Scorecards using Report and Analysis Studio in Cognos 8.2 Version.
• Implementedstored procedures and functions to meet the dynamic nature of SSIS packages and SSRS Reports existing softwareapplication requirements.
• Involved in Migration of data from Navision into SQL Server 2005 using SSIS Packages.
• Created dynamic packages in SSIS to meet the requirements and created Database Maintenance Plans for the various data Sources and centralizing the data using SSIS.
• Extracted data from SSAS cubes to create complex reports according to end user requirements.
• Involved in Performance Tuning is performed for rebuilding Indexes.
• Documented all the process involved in maintaining the database for future references.

Environment: SQL Server 2005, Cognos 8.2, Windows 2003 Server, Spotlight, MS Excel, MS Access,, System monitor/Performance Monitor, Informatica.

Confidential, San Antonio

SQL Server SSIS/SSRS Developer

Responsibilities:

• Developed Complex Stored Procedures and Functions for supporting efficient data storage and manipulation.
• Create User Defined Functions depending upon the requirements. Create User Defined Functions depending upon the requirements.
• Was involved in working with the Data Extraction and Merge into central repository.
• Created DTS and SSIS packages for the Data Flow.
• Worked with different data sources like DB2, Oracle and Access.
• Good experience in working with Data Transformation tasks such as Conditional Split, row count, Copy Column, Derived Column, look up, Merge and Merge Join tasks
• Created configuration files for Deployment of SSIS packages onto Different server.
• Created Dimension and Fact tables.
• Built Multi Dimensional Cubes using SSAS.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created detailed reports and Drill Down reports in SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Created and maintained Login Roles for Database Users.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.

Environment: SQL Server 2000/2005, Enterprise Manager, T-SQL, ERWIN, Data Transformation Services (DTS), ASP.NET, SSIS, SSRS, SSAS.

Confidential, Omaha, Nebraska

SQL Server SSIS/SSRS Developer/DBA

Responsibilities:

• Applied Patch/Re-link Confidential owned software and upgrading MS SQL Servers.
• Created new database and altered the Databases.
• Developed stored procedures and DTS packages to import daily updates from production database which also include visual basic code.
• Created jobs and job steps to run DTS packages which created CSV files of the new/modified demonstrators and new/modified orders for the activities done on the previous day.
• Migrating packages from DTS to SSIS 2005
• Used several transformations like mail merge, FTP, bulk insert to load the data
• Developed several SSRS reports using SSRS 2005.
• Created several drill through, Cascading and parametric reports.
• Created Database Maintenance Plans for the performance of SQL Server, which involves Database Integrity Checks, updating Database Statistics and re-indexing.

Environment: SQL Server 2000, T-SQL, Data Transformation Services (DTS), SSIS, SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Installed, configured and setup SQL Server 2000 on Windows standard environment.
• Analyzed, designed, developed, implemented and maintained SQL Server databases.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Data transformed and uploaded using DTS from MS Excel, text file to SQL Server database.
• Performed tuning/capacity planning using SQL Server Profiler and Windows System Monitor.
• Mentored database analysts in database administration activities providing training, exercises and task supervision.
• Upgraded and upsized databases from earlier versions to the latest versions.
• Responsible for testing and implementing hot fixes, security patches and service packs.
• Organized extensive usage of database, index structures and views.
• Estimated space requirements for databases.
• Planned the complete back-up of databases and restored databases from disaster recovery.
• On call 24/7 support for production server/database issues.

Environment: SQL Server 2000/7.0, Windows NT 4.0/2000, T-SQL, JDBC, .NET, ASP.NET, Java, XML and HTML.

Confidential

SQL Server Developer

Responsibilities:

• Designed Sales Monitoring and Retail Trading database from the existing system.
• Created Stored Procedures, User-defined Functions to take care of back end validations when transferring data to Production Server.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality Implemented backup and database maintenance plans.
• Created DTS packages and jobs to monitor, backup, import/export data and data warehouse extracts.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Performance monitoring and tuning of SQL Server queries.
• Import and Export of Database objects.
• Worked to establish connectivity between VB Applications and MS SQL Server by Using ODBC.
• Administering MS SQL Server by Creating Logins and assigning appropriate roles. Was involved in design of Database.

Environment: MS SQL Server 2000, Windows NT, SQL Profiler, Access, Excel, Windows 2000, Query Analyzer, Enterprise Manager.