PROFESSIONAL SUMMARY

• 7.5 years of IT experience in Data analysis, design, implementation and administration of BI solutions wif MicrosoftSQLserver 2012/2008R2/2008/2005 in development, testing & production environments.
• Extensive experience in BI suite using integration services (SSIS) for ETL (Extraction, Transformation & Loading), reporting services (SSRS) for creating different types of reports.
• Extensive experience in Database activities like data modeling, database design, performance monitoring.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel and .net.
• Proficient in implementing business logic using stored procedures, Functions, Triggers, Views, Complex queries on using T - SQL.
• Experience in creating jobs throughSQLServer Agent for SSIS packages.
• Experience in creating Jobs, Alerts,SQLMail Agent, Scheduled DTS and SSIS Packages.
• Excellent understanding of data mining algorithms, high performance and optimal algorithms.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Experienced in creating and generating AD HOC Reports, Scheduled Reports, Data extracts for business analysis usingSQLServer Reporting Services (SSRS) and Excel.
• Developing reports usingSQLServer reporting services (SSRS), Crystal reports, and Excel tools from a variety of data sources.
• Excellent team work spirit and capable of learning new technologies and concepts.
• As a Developer I has implemented SSRS Business Intelligence Life cycle such as Configuration of Report server Configuration, Deployment of reports, creating report subscription (Data Driven) in Development, Test, Production environments.
• Exposure to all phases of software development life cycle (SDLC) wif in-depth knowledge of agile methodology, enterprise reporting life cycle,SQLserver migrations, change control rules, source controls, problem solving skills and escalation procedures.
• Performed backup/restore of database objects such as tables, procedures, Triggers, constraints, indexes and views, user security management.
• SQL Server Integration Services (SSIS)
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, and Fuzzy lookup, Fuzzy Grouping, Pivot and Un-Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, and Parameterized Reports using SQL Server Reporting Services (SSRS)
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, DB2, MS Access.

Database Tools: MS SQL Server (2005/2008/2008 R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS)

Development skills: T-SQL, PL/SQL, SSIS/SSRS.

Languages: VB.net

ETL Tools: DTS, SSIS (SQL Server Integration Services)Reporting Packages SQL Server Reporting Services, MS Excel.

Tools: MS Project, SQL Profiler, Toad, TFS 2010

Operating Systems: Windows XP, Windows 7,Windows 8, Win -2003/2008/R2

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks, CA

Sr.SQLServer BI/SSIS/SSRS ETL Developer

Responsibilities:

• Designed complex SSIS packages wif error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, data conversion, derived columns and Merge join.
• Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports. Worked wif tabular, matrix, gauges, Maps for Sales by region & chart reports, drill down reports as well as interactive reports according to business requirements.
• DesignedSQLSSIS Packages to extract data from various data sources such as Sybase, Excel spreadsheet and flat files intoSQLServer 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS.
• Develop/maintain from simple to complex reports that might include sub-reports and drill down capabilities and other features supported by SSRS.
• Coordinated wif source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs and resolve the problems.
• Worked on Analysis, Data mapping, implementing the business rules and logic as per the BRD requirements and Data Dictionary.
• Implemented business rules and requirements using multiple transformations like Conditional Split, Look up. Migrated data from heterogeneous sources like Excel, DB2, Oracle and Main Frame toSQL Server 2008.
• Developed scripts/batch files/jobs for Development, QA and Production environment to run AD HOC and scheduled jobs.
• Debugging, fixing errors, removing redundant code, improving query performances existing queries.
• Documenting every report and delivering the reports to end users and sharing it among UCCE team using SharePoint portal for QA/UAT testing.
• Created complex stored procedures for reports, creating indexes, functions for maintaining duties like performance tuning.
• Created various SSIS Packages using different transformations such as Lookup, Multi cast, Merge, Merge Join and union based on requirement criteria.

Environment: SQLServer 2012 Enterprise Edition,SQLProfiler, SSRS, SSIS, Visual Studio 2008/2010/2012 , SSMS,SQLServer Agent, TFS 2012.

Confidential, Union, NJ

BI Developer

Responsibilities:

• Understanding the old legacy process and creating new ETL packages for the Compliance and Audit systems.
• Worked on Migration and Conversion of DTS 2005, 2008 SSIS ETL packages to 2012 ETL packages.
• Converted the Biller Compliance and Accounts payable ETL as per the new SSIS ETL 2012 template.
• Created views, synonyms, store procedures, performance tune the queries in store procedures.
• Developed reports usingSQLServer reporting services (SSRS) fromSQL databases.
• Created reports using queries and rendered the reports in various formats like Excel, PDF etc.
• Added new functionality to the existing store procedures to implement the changes as per the newly designed framework.
• Parsed the files and converted the old logic to use store procedures instead of script in old DTS packages.
• Implemented business logic using T-SQLprogramming and new featuresSQLServer 2012.
• Working in Agile Scrum Methodology wif weekly meetings and interacting directly wif banker connection users. Great knowledge working wif TFS for visual studio 2012 for tracking the current projects, checking in and checking out the latest versions of the code development.
• Working wif Production support team and maintain the on call schedule for SSIS packages.
• Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.
• Worked on various SSIS Tasks like ExecuteSQLTask, FTP task, and send mail task, for each loop container, merge, lookup, sort, conditional split, Character map and derived column.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Experience in creating complex SSIS packages using proper control and data flow elements.

Environment: SQLServer 2012 Enterprise Edition,SQLProfiler, SSRS, SSIS, Visual Studio 2008/2010/2012 , SSMS,SQLServer Agent, TFS 2012

Confidential, Dallas, TX

SQLBI Developer (SSIS and SSRS)

Responsibilities:

• Worked in Agile Scrum Methodology wif daily stand up meetings, great knowledge working wif Visual SourceSafe for Visual studio 2010 and tracking the projects using JIRA.
• Involved in upgrading the databases and servers ofSQLServer 2008R2 toSQLServer 2012.
• Helped BI Team in moving all the deployed reports to Mobile BI Interactive Analytics (IPAD, IPhone) and dashboards using Roam BI Enterprise server.
• Developed Query for generating drill down reports in SSRS. Prepared AD HOC reports through report builders.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures.
• Designed SSRS reports wif sub reports, dynamic sorting, defining data source and subtotals for the report.
• Experience wifSQLServer Reporting Services (SSRS) to author, manage and deliver both paper-based and interactive Web-based reports.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Created subscription to various internal financial, student, college reports using SSRS and involved in migration of SSRS fromSQL2005 toSQL2008R2.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements usingSQLServer Reporting Services.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated users and to administrative Clients.
• Developed reports using SSRS and published as PDF, Excel and CSV formats.
• Created ETL packages wif different data sources (Flat Files, Excel, Oracle, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used For each loop for iterative loading and send mail task for E-mail notifications.
• Migrated DTS objects toSQLServer Integrated Services environment, migrated data from Orion environment toSQLServer 2012 viaSQLServer Integrated Services.

Environment: SQLServer 2008 R2/2012 Enterprise Edition, OLTP, OLAP T-SQL,SQLProfiler, Report Builder, ORION, SSRS, SSIS, Visual Studio 2008/2010, Visual SourceSafe 2005/2008, JIRA.

Confidential, Oaks, PA

MSSQLDeveloper

Responsibilities:

• Gatheird the business requirements in order to create database.
• Involved in the project planning and scheduling of database module.
• Created Logical and Physical data models using Erwin data modeling tool.
• Scheduled and performed transfer of data from various sources like flat file, Excel, Access,SQL Server 2005 database using DTS and filtering the data for data analysis.
• Developed stored procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes,SQLjoins and statements for applications using T-SQL.
• Engaged in report development surrounding QNXT and custom SSRS reporting.
• Managed and monitored the system utilization by using the query optimizer, checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
• Analyzed data quality, worked in the data warehouse architect on the development of logical data models.
• Performed Database Normalization to avoid data redundancies.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Planned the complete back up of databases for disaster recovery scenarios.
• UsedSQLProfiler to optimize the queries.
• Developed stored procedures and Triggers to facilitate consistent data entry into the database.
• Generated various Report models on Views and deployed them on to the production reporting server and generated various Report models.
• Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
• UsedSQLProfiler for troubleshooting, monitoring, optimization ofSQLserver 2008 andSQLcode.
• Worked wif T-SQLto create Tables, Views and Triggers and stored procedures.
• Provide training and knowledge transfer to internal staffs.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Performance tuning MDX and dimensions design and scaling to large numbers of users inSQL Server Analysis Services (SSAS).

Environment: MSSQLServer 2008, 2005 Enterprise Edition, DTS, T-SQL, Query Analyzer,SQL Profiler, Windows 2003 Server, Erwin 4.0, Crystal Reports 9.0, Excel, MS Access.

Confidential, Atlanta, GA

SQLBI Developer/ Data Analyst

Responsibilities:

• Designed, implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complexSQLstatements.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Involved in performance tuning and optimization on Business objects Universes by creating Aggregate tables.
• Created Scripts to copy Database Schema and all the objects..
• Demonstrated architecture, design and delivery experience in the full lifecycle of data.
• Created automated stored procedures for day end operations usingSQLServer agent.
• Coordinated wif front-end for implementing logic in stored procedures and functions.
• Created scorecards wif executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that display performance monitoring measures for sales, sales trends and book return rates for a fictitious book publisher deriving data from aSQLServer 2005/2008 OLAP data source and deployed them to SharePoint sites.
• Created score cards wif advanced set of dashboards using MS Office Performance Point Server 2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends for a fictitious construction company extracting data from aSQLServer 2005/2008 OLAP data source and deployed them to SharePoint sites.
• Performance tuning ofSQLqueries and stored procedures usingSQLProfiler and Index Tuning Wizard in SSAS and SSIS.
• Experience in Data Warehouse design and loading.
• Implemented failure alerts using email in SSIS.
• Created and used extended stored procedure in SSAS.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, and charts and synchronized queries. Administered interface to organize reports and data sources, schedule report execution and delivery and track reporting history using SSRS 2008.

Environment: SQLServer 2008, MS Access, Excel, Windows Server 2008, VSS, ERWIN, Microsoft Visual Studio 2008/2010, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio.

Confidential

Database Analyst

Responsibilities:

• Created complex stored procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code andSQLjoins for applications.
• Implemented different types of constraints on tables.
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Maintained the physical database by monitoring performance, integrity and optimizeSQLqueries for maximum efficiency usingSQLProfiler.
• CreatedSQLServer Reports using SSRS 2005.
• Formatted the report layout for the requirement of the end users. Deployment of the developed reports on to the server for the end users.
• Identified the Data Source and defined them to build the Data Source Views. Developed Query for generating drill down reports in SSRS 2005.
• Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked wif Parameters for parameterized reports in SSRS 2005.
• Responsible for scheduling the subscription reports wif the subscription report wizard. Deployed the generated reports directly on the client's workstation.
• Responsible for transferring the data using SSIS packages. Developed, monitored and deployed SSIS packages.
• Analyzed reports and fixed bugs in stored procedures.
• Analyzed existing stored procedures using DB Tuning advisor for performance improvements.
• UsedSQLServer Profiler for monitoring production stored procedures and MDX-embedded stored procedures for performance tuning.
• Maintained the physical database by monitoring performance maximum and integrity efficiency usingSQLProfiler and DBCC utilities.
• Used System Tables, system stored procedure, DBCC commands for Database maintenance. Developed physical data models and create DDL scripts to create database schema and database objects.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Environment: MSSQLServer 2005/2008, SSIS, SSRS, Visual Studio, T-SQL.

Confidential,

Database Analys

Responsibilities:

• Working wif team of 6 developers, 2 QA and 2 BA to implement ideas, coding and designing for call center databases wifin banking industry.
• Involved in creating technical documents for each and every report/code development for better understanding.
• Scheduling weekly and monthly jobs for SSIS packages usingSQLServer Agent and also creating SSRS reports.
• Created various tabular, Matrix, Chart, Drill-down/Drill through, sub reports and linked reports using SQLServer reporting services.
• Documenting every report and delivering the reports to end users and sharing it among UCCE team using SharePoint portal for QA/UAT testing.
• Created complex stored procedures for reports, creating indexes, functions for maintaining duties like performance tuning.
• Working wif Production support team and maintain the on call schedule for SSIS packages.
• Created various SSIS Packages using different transformations such as Lookup, Multi cast, Merge, Merge Join and union based on requirement criteria.
• Working wif complex stored procedures, creating views, functions and indexes for better performance of a query.

Environment: SQLServer 2005 R2/2005,SQLProfiler, SSAS, SSRS, SSIS, Visual Studio 2005, SSMS,SQLServer Agent, TFS 2005.