SUMMARY

• 8 years of IT experience in Designing, Development and Maintenance of Database applications using MS SQL Server 2012/2008R2/2008/2005.
• 7 years of experience in Reports Development using SQL Reporting Services SSRS 2012/2008R2/2008/2005.
• 4 years of experience in Data Warehousing using SQL Server Integration Services SSIS 2012/2008R2/2008.
• Hands on experience in SQL Server Analysis Services SSAS 2012/2008R2/2008/2005. Used SSAS Cubes as data source for Reports Development.
• Good knowledge on Relational Database Management Systems RDBMS Concepts with strong experience in Database Design and Programming using SQL Server.
• Expertise in scripting DDL, DML, T-SQL Complex VIEWS, Stored Procedures SP , Functions, Triggers and Indexes .
• Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.
• Proficient in developing all types Tabular, Matrix, List, Drill-Down, Drill-Through, Sub-Reports, and Chart Reports of Complex Reports using SQL Server Reporting Services SSRS .
• Experience in Implementing Dynamic Grouping, Sorting Page Breaking using SSRS Parameters.
• Good Experience in Managing/deploying reports to both the modes/environments SharePoint and Native-Report Manager .
• Good Experience in Extraction, Transformation and Loading ETL in SQL Server database using SQL Server Integration Services SSIS .
• Experience in Implementing Checkpoint, Transactions, Logging.
• Experience in building Package Deployment and Package Configurations.
• Good Experience in Creating and Scheduling Jobs for SQL Server Database and SSIS packages using SQL Agent.
• Expertise in Subscribing Reports Standard and Data Driven Subscription using SSRS in both the modes SharePoint and Report Manager .
• Good Experience in Tuning SQL Queries by implementing Indexes and using Stored Procedures.
• Experience on Oracle SQL/PLSQL Oracle 10g , Microsoft Access Database and Progress Database.
• Expert in troubleshooting/resolving SQL Reporting services and SQL related issues.
• Experience in Software Development Life Cycle SDLC including requirements gathering, writing technical specifications and Production support/Maintenance Activities.
• Experience in Data modeling using Star/Snowflake Schema Design, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and logical data modeling using Erwin.
• Self-starter and quick learner with strong analytical and problem solving /troubleshooting skills.
• Good Experience in Agile Methodology and Water Fall Methodology.
• Good Experience in Logistics, Insurance and Telecom Domains.

TECHNICAL SKILLS

• BI Data Warehouse Tools : SSRS, SSIS, SSAS
• Databases : MS SQL Server 2012/2008/2005, MS Access, Oracle 10g
• Languages : C, T-SQL, C .Net, PLSQL
• App. /Web Servers : IIS 5.0/6.0
• Reporting/ETL : SSRS, SSIS, SSAS, Power Pivot, Performance Point, Report
• Builder, Crystal Reports and Oracle Discoverer
• Platforms/OS : Windows 98/2000/2003/XP/NT/Vista, Windows 7, Windows
• 2003 Enterprise Server
• Version Control Tools : Team Foundation Server, SVN
• Others : SQL Server Data Tools, BIDS, SQL Server Management
• Studio, Visual Studio.Net 2005/2008/2010, Office
• 2005/2008/2010, Erwin 7.2/4.2, FTP, Share Point, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Sr. MS SQL/SSRS/SSIS Developer

• Spencer Stuart is one of the world's leading executive search consulting firms. Founded in 1956 and privately owned, they are the adviser of choice among organizations seeking guidance and counsel on senior leadership needs. They work with clients across a range of industries, from the world's largest companies to medium-sized businesses, entrepreneurial startups and nonprofit organizations.
• Spencer Stuart has been providing clients with the knowledge and advice they need to make informed senior leadership decisions for more than 50 years. Through their portfolio of services, they work in partnership with a range of clients to identify, assess and recruit senior executives and board directors and help organizations evaluate talent and prepare for their future leadership needs.
• Responsibilities:
• Migrated Legacy Crystal Reports to SSRS Reports.
• Interacted with BA and Business in gathering/clarifications on Specification Documents.
• Implemented Dynamic Grouping, Sorting page breaking through parameters for all new SSRS Reports.
• Designed and Developed complex SSRS Reports sub reports, dynamic grouping/sorting basing specification docs and data mapping files.
• Implemented some functionalities using custom code for SSRS reports.
• Scripted complex Stored Procedures, Views and Functions for developing reports.
• Created SSIS Packages by using advanced tools i.e. Lookup, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting .
• Implemented best practices both in SQL Scripting and RDL Designing.
• Assisted the team in resolving complex issue both in SQL Scripting and RDL Designing areas.
• Deployed reports to Application by following deployment process in both Dev QA Environments.
• Developed Reporting Standards Document by Interacting with BA and Business.
• Involved in developing Process Document for the smooth running of the project.

Environment: SQL Server Data Tools SSRS, SSIS 2012 , SQL Server 2012, Report Builder 3,Team Foundation Server, SVN, VB.Net, Windows 7, ApexSQL Search, JIRA

Confidential

MS SQL/SSRS/SSIS Developer

Confidential is a leading asset-light based transportation and logistics services provider, head quarter at Dublin, Ohio. Within North America, Pacer manages one of the most comprehensive double-stack intermodal networks with more than 100,000 route miles of double-stack rail operations, integrated with a nationwide truck drayage network for door-to-door service delivery. Pacer accounts for about 20 of all domestic intermodal container moves in the U.S. and is the largest single provider of intermodal container services between the U.S. and Mexico.

Responsibilities:

• Involved in gathering requirements from Business by interacting with the Users directly/conference call.
• Designed and Developed Complex Reports using sub reports as requested by Business.
• Migration of Oracle Reports Discoverer to SSRS Reports.
• Involved in Designing, Developing and Testing of the ETL Extract, Transformation and Load strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages and scheduled jobs SQL Agent in moving FTP files from one server to another.
• Designed ETL packages dealing with different data sources ADO.Net/OLEDB/ Flat Files and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Migrated data from Legacy systems Oracle 10g to SQL Server 2012 using SSIS.
• Pulled Data from different systems and loaded to SQL Server 2012 using SSIS.
• Written Complex Stored Procedures, Functions and Views.
• Created and Scheduled Jobs using SQL Agent for Database and SSIS.
• Created and Implemented Subscriptions for SSRS Reports on both Native Report Manager and SharePoint Mode.
• Support and Maintenance for existing SSRS reports and ETL.
• Performed Peer Reviews for reports developed by other developers.
• Implemented best practices in Reports, ETL Packages and SQL Scripting.

Environment: SQL Server Data Tools SSIS, SSRS 2012 , SQL Server 2012, Report Builder 3, SharePoint, Team Foundation Server, C .Net, Windows 7, Erwin 7.2

Confidential

MS SQL/SSRS Developer

Confidential is a provider of telecommunication and data communication systems, and related services, covering a range of technologies, including especially mobile networks. Ericsson is currently the world's largest mobile telecommunications equipment vendor with a market share of 35 . Directly and through subsidiaries, Ericsson also has a major role in mobile devices and cable TV and IPTV systems. Ericsson was also the inventor of Bluetooth.

Responsibilities:

• Developed SSRS reports based on the user stories similar to use cases in each sprint Agile Methodology .
• Involved in Sprint Planning and Estimation for the requirements.
• Designed and Developed Complex Chart Reports, Drill-Through Reports, Form Reports and Tabular Reports.
• Written Complex Stored Procedures, Views and Functions.
• Conducted Peer Review for the reports developed by other developers.
• Involved in Production Support Maintenance for earlier releases.
• Configured Report Builder and trained business users so that they could create reports from the report models I created.
• Implemented the Best Practices and Standards for SQL Server Scripting and SSRS.
• Performed Unit Testing and Defect Fixing in all the phases of the project SIT, UAT .
• Interaction with Sales Process Team, CRM Team, Testing Team, and Integration Team for better understanding of the functionality.
• Worked along with Usability team in developing UI for developed Reports.

Environment: BIDS SSIS, SSRS 2008/2008R2 , SQL Server 2008/2008 R2, Report Builder 2, Microsoft Dynamics CRM 2010, Team Foundation Server, .Net, Windows XP, QC, Erwin 4.2

Confidential

MS SQL/SSIS/SSRS Developer

Confidential is an American public multinational corporation headquartered in Chicago, Illinois, USA. It is the leading provider of risk management services, insurance and reinsurance brokerage and human capital and management consulting. Aon is known internationally as the principal sponsor of the English Premier League team Manchester United.

Responsibilities:

• Migrated Procedures and functions from legacy Oracle 10g to SQL Server 2008.
• Designed and developed SSRS reports exactly similar to the Crystal Reports Migration of Crystal Reports to SSRS Reports .
• Created complex Stored Procedures, SSIS Packages, Triggers, Cursors, Tables, and Views and other SQL JOINs and statements for applications.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Worked with Integration Services SSIS for transferring and reviewing data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data .
• Created and Tuned Event Handlers, Checkpoints and Logging to maintain active SSIS packages.
• Extensively utilized SSIS packages functionality to create complete ETL Process using scripts, stored procedures, functions, transformation of data.
• Configured SQL Mail Agent for sending automatic emails when a SSIS package is failed or succeed.
• Designed and Developed Drill-through, Drill-down, Cross Tab Matrix Reports and Sub-Report using SSRS.
• Optimized the performance of queries by Data Manipulations which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Performed Unit Testing for migrated procedures, functions and RDLs.
• Implemented the Best Practices and Coding Standards for SQL Server, SSIS SSRS.
• Also Performed QA for the reports that was assigned.

Environment: BIDS SSRS, SSIS 2008 , SSMS, SQL Server 2008, Oracle 10g, Toad, Crystal Reports, Share Point, Windows XP, MS Excel, Test Manager, TFS.

Confidential

MS SQL Server Developer/SSRS

Confidential is a global IT solutions provider leading the off shoring revolution with its cutting-edge services that provide support and impetus to emerging established businesses in the areas of IT consulting, product engineering, social networking, custom software development, application integration and maintenance. It's a global IT solutions provider leading the off shoring revolution with its cutting-edge services that provide support and impetus to emerging established businesses in the areas of IT consulting, product engineering, social networking, custom software development, application integration and maintenance.

Responsibilities

• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and SQL JOINs.
• Designed and created VIEWS for security purposes, implemented rules, defaults, and user defined data types.
• Created Packages to Migrate data from different Data Sources to Data warehouse.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SQL Server Reports using SSRS 2005 for the Business.
• Deployed developed reports on to the clients portal for the end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.

Environment: Windows XP, MS SQL Server 2005, SQL Server Reporting services.