PROFESSIONAL SUMMARY:

• Microsoft SQL Certified Developer with 5+ years of work experience in developing Business Intelligence applications and enterprise Data Warehouses at various phases of SDLC.
• Extensive experience in BI suite - using integration services (SSIS) for ETL (Extraction,
• Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes.
• Highly proficient in the use of T-SQL, creating Relational Database models and maintaining Data integrity.
• Strong proficiency in the use of T-SQL for developing complex stored procedures, triggers, tables, user-defined functions, relational database models and data integrity, SQL joins and query writing.
• Experience in transforming unstructured data from various data sources using SSIS
• Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements.
• Experience in developing Drill through and Drill down reports, Parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
• Strong knowledge of Mortgage Services and loan processing.

CORE COMPETENCIES:

ETL: SQL Server Integration Services (SSIS)

RDBMS/DBMS/Server: MS-SQL 2012, 2008R2, 2005, Oracle 9i, MS Access 2003/2007, Btrieve, Sybase and FoxPro 2.6

Reporting Tools: SQL Server Reporting Services (SSRS)

Data Modeling: Data modeler and MS Visio 2010

Testing Automation Tools: WinRunner 6.x/ 7.x, Quick Test Pro (QTP) 8.x/9.x and LoadRunner 9.x/9.x

Testing Techniques: Verification and validation techniques, Black box testing and automation

Application Testing: GUI testing, Functional testing, User Interface testing and Integration testing.

Defect Trackers: Quality Center 8.x/9.x/10.x, Test Director 6/7.6, Mantis, GForge, BugZilla and Jira

Scripting Languages: Test Script Language (TSL) and VB Scripting

Programming Languages: C, T- SQL 3.0, PL/SQL and XML

Web Technologies: VB.Net, HTML4.0, XML 1.0, Java, JJ2EE, Hibernate, Spring, ExtJs, JavaScript, VB Script, JavaScript 2.0, ASP 2.0/3/0, JSP and EJB

Browsers: Internet Explorer 8/9/10.0, Netscape 7.2, Fire Fox 1.0 and Chrome

Operating Systems: Windows XP/2000/NT/98/95, Windows Server 2003/2008, MS-DOS 6.22 and UNIX

MS Office Suite: MS Word, MS Excel and PowerPoint

GUI RAD Tools: Magic V9.0/10

PROFESSIONAL HISTORY:

Confidential, Fort Worth, TX

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Developed T-SQLscripts, dynamicSQL, complex stored procedures, functions, triggers and complex join and sub queries inSQLServer Management studio (SSMS).
• Developed various types of complex reports like Drill Down, Drill Through, Gauges, Pie Chart, Bar Chart, Sub-Reports.
• Worked on various tasks and Transformations like Execute SQL Task, Execute Package Task and Conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• UsedSSIStransformation for data cleansing to remove unnecessary columns, eliminated redundant and inconsistent data.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implemented logging to enforce SSIS Package integrity for auditing purpose.
• Addressed data quality by using Conditional Split, Fuzzy Look-Up, and Derived Column.
• Modifying, Enhancing, Performance tuning past SSIS packages to new standards.
• Worked with off shore team to create solutions for enhancing SSIS packages.
• Helped to create Business Requirement Document based on the needs of the end users.
• Hosted several meeting with end users to create user stories and BRD.
• Ability to communicate with Supervisors, Executives, BA’s, DBA’s and Developers.
• Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Developed reports from Cubes using the KPI's for decision making, also debugged data connections, data sources and Data Source Views.
• Used Excel Pivot tables for Sales Analysis.

Environment: Windows Server 2008, SQL Server 2008R2/2005, DB2, Oracle, BIDS, Excel, Notepad++, XML and C#

Confidential, Bothell

SQL Server/SSRS/SSIS/ETL Developer

Responsibilities:

• Developed and documented the physical ETL process design based on business requirements and system specifications with ETL design skills, including source to target mappingstransformations, lookups, aggregations and expressions.
• Developed and maintained T-SQL Stored Procedures, Data Models with Primary Keys and Unique Keys according to the business requirements.
• Implemented complex SQL queries using joins, Try-Catch Blocks, and T-SQL Stored Procedures with Parameters, User Defined Functions.
• Developed a Dashboard using Matrix, Bar Charts, Line Charts, Drilldown reports, Drillthrough reports, Bar Charts and Pie Charts using SSRS Report Designer based on requirements.
• Created complex queries and expressions for various reports in SSRS.
• Created packages using Integration Services (SSIS) for extracting data from XML, Excel files, OLEDB to SQLServer staging tables before loading into final destination.
• Responsible for creating Parent and Child packages with email notifications on success.
• Used SSISto create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Assisted other developers with package creation and error handling.
• Addressed data quality by using Conditional Split, Fuzzy Look-Up, Derived ColumnModifying, Enhancing, Performance tuning past SSIS packages to new standards.
• Worked with off shore team to create solutions for enhancing SSIS packages.
• Help to create Business Requirement Document based on the needs of the end users.
• Hosted several meeting with end users to create user stories and BRD.
• Ability to communicate with Supervisors, Executives, BA’s, DBA’s, Developers Optimized Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).

Environment: Windows Server 2008, SQL Server 2008R2/2005, Oracle, BIDS, Excel, Notepad, XML and C#

Confidential, Chicago, IL

SQL Server/SSIS/SSRS/ETL Developer

Responsibilities:

• Gathered business requirements, definition and design of data source and data flows.
• Analyzed source system data to determine the data model and ETL solution that will meet business requirements and involved in creating DataWarehouse and DataMart.
• Created complex SSIS package using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
• Worked on T-SQL programming, stored procedures and views in the process of developing reports.
• Implement Star schemas while designing relational database and data warehouse as per business and report requirements.
• Defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations, KPI’s, perspectives and roles.
• Created and designed OLAP cubes.
• Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
• Generated Sub-Reports, Drill down reports, Drill through reports, Parameterized reports, Toggle reports, Chart reports, Gauge reports, Map reports(by territory, by country, by state) using SSRS.

Environment: Windows server 2003, SQL Server 2005 enterprise edition, BIDS, SSRS and SSIS.

Confidential, Memphis, TN

QA Team Lead

Responsibilities:

• Wrote test cases based on user cases and requirements.
• Performed functionality, integration, GUI, system, database, regression, acceptance and load.
• Tested newly released builds of application on test servers.
• Participated in daily scrum meetings to report QA work on a daily basis.
• Reported defects and issues using Mantis Defect Tracker.
• Used “Execute query” Tool to query database.

Environment: Windows XP, Java, J2EE, WebSphere, JSP, Hibernate, Spring, ExtJs, FireFox, HTML Validator, Mantis, MS-SQL Server 2005 and MM Connect.

Confidential

QA Tester

Responsibilities:

• Performed manual Testing of Front Office Module (OPD / IPD-Registrations) and Appointment Module (Doctors/OT)
• Checked for links, Table, Images, Navigation, Look n Feel, Alt-Text and functionality
• Performed Regression Testing for all modules.
• Logged Defects in TestDirector 7.0 and communication to Supervisor.

Environment: Java, JSP, Apache, HTML, Java Script, SQL Server, Test Director, Windows 2000