SUMMARY:

• Extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R 2/2012/2014.
• Experience in Writing TSQL (DDL, DML AND DCL), developing/creating new database objects such as Tables, Views, Indexes, Complex stored procedures, function(UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs), Backups, Recovery and SQL Server Agent profiler using SQLSERVER 2000/2005/2008 R 2/2012/2014.
• Extensive knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
• Performance Tuning in SQL Server - Using SQL Profiler, DETA (Tuning Advisor), HINTS, Effective use of DMV’S/DMF’s, Optimization for AD-HOC Workloads, Plan Guides, Parameter Sniffing, DBCC commands, Partitions & Partitioning, Bulk Loading Data(BCP),Indexed Views & Schema Binding, STATS, Clustered/Non Clustered Indexes.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse and OLAP Cubes.
• Experience in developing several Detail, Summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Experience as Report Writer for understanding each client business reporting requirement, designing, creating and maintain of simplex to complex reports.
• Experience in generating reports for OLTP and OLAP databases.
• Experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SSRS.
• Heavy experience in deploying and configuring packages, Error handling and batch logging, check points and troubleshooting Reports using SSRS.
• Hands on experience working with Self Service MS BI end user tools such as Excel 2010 (Power pivot),Performance Point Service(PPS), Power view.
• Developed the SSAS 2012 Multidimensional and Tabular model reports from Data warehouse using SSDT.
• Experience in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, Sybase, DB2, MS access using SQL Server SSIS 2000/2005/2008 R2/2012/2014
• Proficient in Extraction Transformation and Loading (ETL) process by pulling large volumes of data (VLDB) from various data sources using SSIS.
• Worked in Migrating of DTS Packages to SQL Server Integration Services (SSIS) from Lower Version (2000/2005) to Higher Version (2005/2008/2012 ) and troubleshoot migration issues.
• Experience in designed Data Conversions from wide variety of source system using SSIS.
• Experience working with different SSIS Configuration options and Deployment Methods for different environments use.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience working with Data Cleansing technique in ETL process.
• Hands on experience working with different types Dirty Data from different sources.
• Hands on experience loading Data warehouse for both Dimension tables and fact tables by initial load/ongoing load process using SCD, MERGE, CDC, Parent/Child SSIS packages.
• Excellent Hands on Logging, Error handling using Event Handlers pre and post for SSIS Packages.
• Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and Snow Flake schema) using SQL Server 2005/2008/2012/2014 Analysis Services (SSAS).
• Excellent hands on experience in creating groups and measures, KPIs.
• TFS,SVN
• ERWIN, Power Designer
• Application Architecture/HLD Documents, Requirement Document(BRD),Detailed Design Documents(FSD/LLD),Maintenance and Operations (M&O) Documents, System Interface Documents, Data Model Documents, Configuration Management Documents
• Sound Knowledge in front end applications like C# .NET, ASP.NET.

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i, DB2

Database Tools: SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX,DAX, COBOL

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012/2014

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite, AutoSys, Quality Control(QC),Tidal Jobs.

Architecture: Relational DBMS, Client Server Architecture, OLAP, OLTP

IT Processes: Software Development Life Cycle (SDLC)

Methodologies: Agile, Waterfall, Scrum, SDLC.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Team Lead

Responsibilities:

• Attended the application's KT in Palo Alto, CA as Team Lead in CLQR project where Confidential -I are receiving layer from Confidential -E.
• With the supervisory role responsible for project planning and estimates, participating in client meetings for understanding functional and business prospective of the project.
• Responsible for understanding the complex SSIS packages and make understandable to the team.
• Responsible for understanding the SSAS cubes and SSRS reports to team.
• In SSIS packages - worked with Flat File(.Zip) data sources and loading the flat files in the folder into target Sql Server db by performing different kinds of transformations and considering the business rule for never reprocessing a file that has already been processed using SQL Server Integration Services (SSIS).
• Populated SSAS cubes using SQL Server Integration Services (SSIS).
• Worked on Tidal Job scheduler for scheduling batch files which contains the SSIS packages using DTExec command
• Responsible for creating documentation on all the applications so that out team can validate the information that we took from other team and also useful for giving demos to higher management.
• Dealt with SSRS Reports which we are getting from SSAS cubes.
• Created the automated process for performing the bulk load using vertica into Hadoop environment.

Environment: SQL Server Data Tool 2012/2014, SQL Server 2012/2014, SSIS (2012/2014), SSRS (2012/2014), SSAS(2012/2014), Tidal Jobs, Visual Studio 2010/2013,Vertica,Hadoop.

Confidential, Richfield, MN

SSRS| SSIS|PDW|T-SQL - Team Lead/ Developer

Responsibilities:

• Worked as Team Lead defining the project requirements, assigning tasks to onsite/offshore teams, supervising their work and reaching deadlines.
• With the supervisory role responsible for project planning and estimates, participating in client meetings for understanding functional and business prospective of the project.
• Organized the Business meeting with business partners for gathering report requirements.
• Responsible for converting Teradata scripts into SQL Server scripts.
• Experience working with Relational Data Modeling using Power Designer.
• Involved in writing T-SQL Programming for implementing Complex Stored Procedures and User Defined Functions for different tasks.
• Created and debugged complex stored procedures, views and functions for better performance and flexibility.
• As Report Writer, Created reports by generating data models and also generated Ad hoc reports.
• Responsible for designing ETL solutions/ framework with SSIS.
• Responsible for the performance tuning of the ETL packages.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked on various tasks and transformations likeExecute SQL Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination.
• Worked on Maestro job scheduler for scheduling teradata scripts and 2012 SSIS packages.
• Responsible for different Data source Team meeting and mapping their columns to SQL Server 2012 in PDW(Parallel Data Warehouse) Environment .
• Responsible for creating HLD/LLD Design documentation.
• Reports were developed on Excel 2010, Power Pivot for providing ad-hoc/Self Service reporting for the clients.

Environment: SQL Server 2012, SSIS (2012), SSRS (2012), Maestro Jobs, Visual Studio 2010/2013,MS Excel 2010,Power Designer.

Confidential, Plano, TX

SSIS|SSRS Report Writer|Cobol Report|Oracle PL/SQL|T-SQL Developer

Responsibilities:

• Converting already existing SSIS packages which are pointing to SQL Server to Oracle 11.
• Converting COBOL Program to specification document so that it can be used to convert to Oracle PL/SQL Stored Procedure/Function/views.
• Analyzed business requirements and used COBOL program specification document so that it can be used to convert to Oracle PL/SQL/SQL Server Stored Procedure/Functions/Views.
• Query Optimization, Tuned some SP’s/Queries/views for excellent performance upgrades like one Job was taking 6.5 hours reduced it to 1.5 minutes.
• Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle.
• Created/Modified multiple SSIS packages. SSIS packages were used to bring the application data from SQL Server to oracle and to text files as extracts/reports. Also used SSIS packages to store data on third party FTP sites.
• As Report Writer I Designed and implemented reports with different layouts using SSRS 2008R2 and also with mainframe systems.
• Created several Complex Reports (tabular, matrix, sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Done apple to apple comparison of Cobol reports and SSRS.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Worked on Defect Fixing Using Quality Control (QC).

Environment: SQL Server 2008/2012, SSIS (2008/2012), SSRS (2008), Oracle 10/11 PL/SQL, Visual Studio, COBOL, QC

Confidential, Charlotte, NC

SQL Server SSRS|SSIS|SSAS|T-SQL Developer

Responsibilities:

• Created the ETL (SSIS) packages and scheduled them for SQL Agent Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Extensively worked in data integration in developing ETL mappings and scripts using SSIS
• Data migration (import & export - BCP) from Text to SQL Server and Vice versa.
• Implemented batch processing using Jobs and DTS.
• Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for codingSSISprocesses to import data into the Data Warehouse fromExcelspreadsheets, Flat Filesand OLEDB Sources.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2008 Reporting Services.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Used Script task for setting the SQL query on fly using C#/VB in SSIS package

Environment: SQL Server 2008 R2, SSIS 2008 R2, SSRS 2008 R2, BIDS 2008R2, SQL Profiler, Visio, C#/VB, Excel 2007

Confidential, Rochester, NY

SQL Server SSRS|SSIS| Oracle SQL

Responsibilities:

• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2008/2005 using Oracle 11g as the data source.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex).
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.
• Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008 R2.
• Comfortable mentoring others in my team for complex SSRS reports.
• Data Transformation Activities using DTS Import/ Export for transferring data between different databases like Oracle.
• Design new DTS packages as per needs, Resolve the problems.
• Migrated data from different environments to SQL Server 2008 R2 via SSIS and also applied conversion and transformation procedures according to business requirements.

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, MS Visual Studio 2008, Oracle SQL Developer (3.0.04)

Confidential, Cleburne, TX

SQL Server Developer |SSRS|SSIS | T-SQL

Responsibilities:

• Used Workforce Central Management 6.1 version tied the SQL Database to the workforce management by using SSMS and verified the created 120 SSRS reports from user perspective to make sure right amount of data is processed.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Worked on RDL‘s of the reports and promoted those RDL’S to WFC portal.
• Troubleshoot SSIS Packages and convert to SSRS Reports.
• Responsible for Debugging reports using Stored Procedures.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.
• Promoted RDLs to Reporting Service Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.
• Responsible for creating/migrating undocumented crystal/SSRS reports.
• Created and modified efficient Stored Procedure and functions which implement necessary business logic to support the front end application to facilitate pulling data.
• Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer.
• Create new SSIS Packages to export flat file for customer.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created package to transfer data between OLTP and OLAP databases.
• Assisted front-end C#.NET and ASP.NET developers using Visual Studio 2008 (C#, ASP.NET).

Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports XI, Visual Studio, T-SQL, C#.NET, ASP.NET

Confidential, Logan, UT

SQL Server Developer |SSRS|SSIS | SSAS | T-SQL

Responsibilities:

• Performance Tuning, Analyze tuning and optimizing for SQL Server Application by using performance monitor.
• Dropped and recreated the Indexes on tables for performance improvements.
• Maintained the consistency of the client’s Database using DBCC.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning SQL Server performance.
• Worked with error handling methods in SQL Server 2005 and SQL Server 2008.
• Created and Maintained large Data Marts of extracted data using Dimensional Model.
• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts, usage of Tablix (new feature of SSRS 2008), use of filtering conditions.
• Developed different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Cross-Tab, Conditional reports, sub reports and ad-hoc reports using MS SSRS 2008.
• Developed an ASP.NET web service for Crystal Reports using Visual Studio 2008.
• Designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, TIFF and CSV using SSRS2008.
• Created SSIS packages to transfer data between OLTP and OLAP databases.
• Created and Configured Cubes using SQL Server 2008 Analysis Services.
• Designed Data Warehouse Database for both Start and Snow Flake Schema.
• Enhanced the functionality of Cube by creating KPI, Actions and Perspective using SQL Server 2008 Analysis Services.
• Created MDX queries to access cube information.

Environment: SQL Server 2008, BIDS 2008, SSRS 2008, SSIS 2008, SSAS 2008, DTS, Crystal Reports, ad-hoc, Business Objects, VB, MS Access, Windows XP, Visual Studio, Visio 2007,T-SQL, ASP.NET

Confidential, Lexington KY/ Boston, MA

SQL Server Developer |SSIS|SSAS| T-SQL

Responsibilities:

• Primary role was SQL Server Developer with SSIS and SSAS.
• Created and executed SSIS (.dtsx) packages to extract data from the various data sources such as flat file, excel and from other database such as Oracle and by different data loading operations for many applications which is main purpose of ETL development using SSIS 2005/2008.
• Wrote DTS/SSIS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Created tables for data ware housing applications and populated the tables from the OLTP database using DTS packages.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed cubes by defining data sources and data source views and using SQL server analysis services (SSAS).
• Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Involved in defining Referenced Relationships with the measure groups and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Using MDX created calculated members for customized calculated measures.
• Analyzing the Performanceofa cube by partitioning it and creating Perspective Cubes.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
• Created reports from cubes by writing MDX queries.
• Writing various Stored Procedures, Triggers, Functions, and Views based on the functionality requirements for various teams and also to load data from the OLTP database.
• Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.

Environment: SQL Server 2000/2005/2008 , BIDS 2005/2008, SSAS 2005/2008, SSIS 2005/2008, DTS, MDX, VB, MS Access, Visual Studio, T-SQL, Windows XP

Confidential, Santa Clara, CA

SQL Server Developer|SSIS|SSRS| T-SQL

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Modified current database by adding tables, altering referential integrity and relationships to support the control system.
• Created user defined data types and added them to model database for future purpose.
• Created and debugged complex stored procedures and functions for better performance and flexibility.
• Optimized SQL queries for efficiency and assisted the front end developers with their queries and procedures.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Created clustered /non-clustered indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures.
• Used Triggers to generate customized error messages.
• Design new SSIS packages as per needs, Resolve the problems.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Designed and implemented reports with different layouts using SSRS 2005.
• Design and Implementation of Data Mart for reporting purposes.
• Responsible for installing Business Objects Enterprise management system on production systems and setting up external and internal user’s access and security settings to published reports.

Environment: SQL Server 2005, SSIS (2005), SSRS (2005), Crystal Reports XI, Business Objects, Erwin, Windows Server 2003, Visual Studio

Confidential

Junior SQL Server Developer| Report Writer/Developer | T-SQL

Responsibilities:

• Created SQL server Reports using SSRS 2000 while identifying the data source and defining them to build the DSV’s.
• Created Queries for generating drill down, critical drill- through reports in SSRS 2000.
• Designed and implemented stylish report layouts.
• Generated Reports using global variables, expressions and functions for the reports.
• Identified and worked with parameters for parameterized reports in SSRS 2000.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Developed complex SPs, triggers, cursors, tables, indexes, constraints, views and other SQL joins for applications.
• Responsible for deploying the generated reports.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Environment: SQL Server 2000, SQL Server Reporting Services 2000(SSRS), T-SQL