PROFESSIONAL SUMMARY:

• 8+ years of IT Experiencewhich includes 6 years of SQL Developer experience and 2 years of Java developer experience.
• Development and Support of Microsoft SQL Server2012/2008 R 2/2008/2005/ 2000 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, Insurance and Health Care.
• Experience inData Schema Design, and Table Design.
• Experience in Using multiple joinstatements to retrieve data from multipletables
• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generatingreports.
• Worked in SDLC(Systems Development Life Cycle) for developing systems/Software
• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning
• Experience in MSBusinessIntelligence tools like SQLServerIntegration Services, AnalysisServices and Reporting Services.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Views, Indexes, User profiles query writing and SQL joins
• Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP and OLAP experience with experience on SSRS, SSIS, SSAS, Data Analysis, Data Cleansing/Data Scrubbing and Data Migration
• Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.
• Proven ability in Performance Tuning, Query Optimization and Running Database
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Hands on experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc reports and distributed reports in multiple formats using SQLServer Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in developing various kind of reports like Cascading parameters, Drill down, Drill through, Sub Reports and Charts.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated Transformations to be used in SSIS packages
• Used DTS/Integration services (SSIS) to migrate data from one system to another and performed several transformations to ensure data integrity and validity
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2008 using SSIS tools like Import and Export Wizard, Package Installation and BIDS
• Experienced in Designing, Building the Dimensions, Cubes with Star Schema and Snow Flake Schemas using SQL Server Analysis Services (SSAS) in SQL Server.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS:

Relational Databases: SQL Server 2012/ 2008R 2/2008/2005/2000, MS Access, Oracle

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe and SQL Query Editor, Toad Data Modeler.

Languages: T-SQL, PL/SQL, HTML, XML, SQL, Java.

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

ETL Tools: SSIS, DTS

Web Technologies: HTML5, CSS, XML, XSL, Java Script.

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

PROFESSIONAL EXPERIENCE:

Confidential

SQL BI (SSIS/SSRS) Developer

Responsibilities:

• Performed all SDLC phases related to extraction, transform, and loading (ETL) processes by usingSQL Server Integration Services (SSIS) andSQLServer stored procedures in MSSQLServer 2005 and 2008 environments
• Developed complex canned reports usingSQLServer 2012/2008 Reporting Services (SSRS)
• Created and maintained data flow diagrams for existing and future ETL processes
• Created and maintained detailed source-to-target ETL mapping specifications
• Participated in on-call support rotation for nightly ETL batch cycles
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency; and resolve other technical problems
• Developed highly optimizedstored procedures, functions, and database views
• Translated business requirements intoBIapplication designs and solutions
• Involved in performance monitoring, tuning and capacity planning
• Developed ETL audits and controls to ensure quality of data to meet or exceed defined standards and thresholds
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Have written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines
• Created stored procedures to be used as datasets for the Report Design
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, Toad Data Modeler, SSRS.

Confidential

SQL Server BI Developer/DBA

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data from Oracle to Sql Server using various transformations in SSIS.
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches.
• Developed Aggregations, partitions and calculated members for cube as per businessrequirements.
• Defined appropriate measure groups and KPIs&deployed cubes.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Responsible for managing daily activities of department including compliance initiatives, group practice agreements, managing health care claim strategies and other.
• Responsible for helping manage the daily operation of the company, meeting with clients and brokers for brokerage, holding employee meetings, resolving conflicts.
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers.
• Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005/2008, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), MDX, SQL Profiler, MS Excel 2003,SharePoint 2007.

Confidential

SQL Server Developer

Responsibilities:

• Dealt with requirements gathering, analysis, design, development, change management, deployment and user .
• Migrated the database from SQL 2000 to SQL 2005 successfully.
• Designed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Created Linked Servers to connect OLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
• Introduced SSRS services to generate different types of reports from the database.
• Performed Data Analysis for automating various Customers Insurance Reports utilizing SQL Analysis Services.
• Designed, programmed, deployed and tested the requested Reports.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: SQL Server 2000 Enterprise Edition, MS Excel, T-SQL, MS Access 2000, SQL Reporting Services, ERWIN, XML, Web Services, Windows NT4.0.

Confidential, CA

SQL Server BI Developer

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions. Deployedand processedOLAP Cubes.
• Developed Aggregations, partitions and calculated members for cube as per businessrequirements.
• Defined appropriate measure groups and KPIs&deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRSand designed reports using Crystal Reports.
• Created report snapshots to improve the performance of SSRS.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment: SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, MSIIS, Visual Studio 2005, Visual Team Foundation Server, Crystal Reports

Confidential

SQL Server BI Developer

Responsibilities:

• Understanding the customer requirements, analysis, design, development and implementation into the system.
• Created complex conceptual database designs in SQL Server 2000/2005 using various constraints procedures and queries in T-SQL.
• 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.
• Migrated data from different sources (text based files, Excel spreadsheets and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extracted data from Oracle and migrated into SQL Server 2005 using SSIS.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through and Sub Reports
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.
• Maintain Disaster recovery strategies for the database and fail-over methods.

Environment: SQL Server 2000/05, SSIS, SSRS, Oracle 9i/10g, ASP .Net, Visual Studio .Net, UNIX, Windows XP.

Confidential

Java Developer

Responsibilities:

• Worked as Software Tester in FEDEX team which consists of 7 members in which the task was to fetch the baselines from FEDEX Logistics and test the test cases through QTP (Quick Test Professional Software) and analyze the errors and this normally comes under AUTOMATION TESTING.
• Concurrently worked as Java Programmer.
• Created or maintained databases of known test defects.
• Installed, maintained, or used software testing programs.
• Collaborated with field staff or customers to evaluate or diagnose problems and recommend possible solutions.
• Documented software defects, using a bug tracking system, and reported defects to software developers.
• Provided technical support during software installation or configuration.
• Concurrently worked on Banking Project as well.

Environment: QTP tool (Quick Test Professional), Core Java, JSP, Servlets, JDBC, Java Script, HTML, JUnit, CSS, MS Word, MS Excel.

Confidential

Java Developer

Responsibilities:

• Worked as Core Java Developer in an application development team which consists of 14 members in which the task was to develop code for small modules in an application which deals with banking operations, and the code is developed on ECLIPSE IDE.
• Worked with Core Java, Servlets, JSP and JDBC.
• Used database connectivity skills Oracle, MS SQL Server, MySQL, and Access.
• Gained extensive Object Oriented Development OOP/OOD experience.
• Wrote, updated, and maintained computer programs or software packages to handle specific jobs such as tracking inventory, storing or retrieving data, or controlling other equipment.
• Wrote, analyzed, reviewed, and rewrote programs, using workflow chart and diagram, and applying knowledge of computer capabilities, subject matter, and symbolic logic.
• Compiled and wrote documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program.
• Prepared detailed workflow charts and diagrams that describe input, output, and logical operation, and convert them into a series of instructions coded in a computer language.
• Developed and directed software system testing and validation procedures, programming, and documentation.
• Prepared reports or correspondence concerning project specifications, activities, or status.

Environment: Core Java, JSP, Servlets, EJB, JDBC, Java Script, HTML, JUnit, MS Word, MS Excel.