SUMMARY

• 15 years of experience in all phases of Software Development Life Cycle (SDLC) such as developing, testing, administrating and production supporting of BI Application, Microsoft Products (ASP.Net, SSIS, SSRS Etc.).
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Expertise in using multiple transformations provided by SSIS such as script component, Look UP, Data Conversion, Conditional Split, Bulk Insert, Aggregate, Execute SQL Task, merge and union all, slowly changing dimensions and many more to transform the data before loading into the destination.
• Created and maintained Databases, creating Roles and managing user permissions.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Data refreshes, Security and User management, Roles, Performance Tuning.
• Scheduling and Monitoring ETL Processes using DTExec utilities and batch files.
• Experience in Performance Tuning and Query Optimization.
• Worked with Business Objects, Crystal Reports, SQL Server Reporting Services for creating complicated reports including sub - reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Extensive experience in database programming using SQL, PL/SQL by using industry best practices in creating and managing database objects like tables, triggers, stored procedures, views, Indexes, functions etc.
• Strong experience in developing Test Plans and Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Hands on experience in Functional Testing, Integration Testing, User Acceptance Testing, and Regression testing.
• Involved in leading and managing resources across the globe.
• Proactive, Quick learner, good team player and an individual with good communication skills.

TECHNICAL SKILLS

Operating Systems: Windows NT/XP/ 2000/2003/2007

BI Tools: Business Objects (XI, 3.1), Crystal Reports XI R2, SSIS, SSRS

Data Modeling: Visio, ERWIN

Query Tools: TOAD, SQL Navigator, SQL Assistant, Query Analyzer

.NET Technologies: VB.Net, C#, ASP.Net, Visual Studio 2010/2013

Programming Languages: C, C++

RDBMS: Oracle 10g, SQL Server 2005/2008, SQL Server Management Studio 2012MS Access, Netezza

XML: XML, XSD, XSL, and XSLT

Web Designing Languages: HTML, DHTML

Scripting Languages: JavaScript, VBScript

App Servers: Apache tomcat, IIS

MS Office: Word, Excel, PowerPoint, Access

Other: SharePoint, Test Director, Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Chatham, NJ

SQL BI Developer

Responsibilities:

• 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 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 coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like Execute Sql Task, Script Task, Data Flow Task, File System task and conditional split, Derived Column, Data Conversion, Script Component, Merge, Union All and Sort while loading the data into Destination.
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Designed and developed Complex Queries, T-SQL Stored Procedures, Triggers, Tables, Constraints, Views, and Functions in MS-SQL Server 2008/2012.
• Scheduled theSSISpackages to run as jobs on periodic basis according to the requirement using SQLServer Agent.
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• CreatedSSISpackages to pull data from SQL Server and exported to fixed width and delimited text files based on client’s requirement.
• ImplementedError LoggingusingEvent Handlers and also implementedlogging inSSIS Packages.
• Responsible for designing, testing and maintenance of Crystal reports for all the existing and new insurance products.
• Creating Invoices, Billing reports using Crystal reports in Visual Studio 2013.

Environment: Visual Studio 2013, Crystal Reports, SQL Server 2008 R2, SSMS 2012, SSIS, SSRS, MS Access, VisualSVN, TFS

Confidential, Warren, NJ

Reports Analyst

Responsibilities:

• Responsible for designing, testing and maintenance of Business Objects/Crystal Reports for the Data Privacy Operations (DPO) office.
• Designed and developed Crystal Reports and Business objects reports which includes standard reports, cross-tab reports, summary reports according to the requirements.
• 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.
• Developed highly complex Crystal reports with challenging design based on the requirements.
• Developed various Charts and Graphs like Bar Charts, Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
• Designed and developed Complex Queries, T-SQL Stored Procedures, Triggers, Tables, Constraints, Views, and Functions in MS-SQL Server.
• Involved in migration of existing Crystal Reports to Business Objects.
• Handled all the complex logic in the backend instead of heavy use of formulas in the reports.
• Created and used tables, views, indexes, stored procedures, triggers, joins to retrieve data from tables.
• Analyze and Fix SQL queries to resolve the report issues.
• Extensively tested the Crystal reports/ Business Objects WEBI reports data by running the SQL queries on the database.
• Coordinating post-implementation events such as testing.

Environment: Business Objects XI 3.1, Crystal Reports XI R2, SQL Server 2008, SSIS, MS Access, Windows XP

Confidential, Parsippany, NJ

Business Objects Consultant

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new/update/enhance universes by implementing STAR schema as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created Universes and universe connections, Derived Tables, classes, objects andjoins between the tables and setup the cardinalities between the joins also resolved loops by using context and alias tables.
• Created stored procedures, triggers, Joins, functions and views.
• Created SSIS Packages to import data from Excel Spreadsheets, Text files and CSV files to SQL server database.
• Migrated universes between the different domains in engineered process from DEV to QA to PROD using import wizard tool.
• Used Saama’s Universe Management tool (UMT) to compare the universes during migration.
• Extensive experience in documenting Universes and reports by using MS Word, MS Excel.

Environment: Business Objects Enterprise XI 3.1, Netezza, Universe Management Tool (UMT), Windows XP, SQL Server 2008

Confidential, Lyndhurst, NJ

BI Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Worked with Functional Architect, DBA, Team members and Analysts to get a clear understanding on the Application.
• Build the new/update/enhance universes by implementing STAR schema as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• 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).
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• ConfiguredSQL mail agentfor sending automatic emails whenSSIS packagesfails or succeeds.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Scheduled SSIS Packages daily, weekly and monthly Basis.
• Creating Stored Procedures for reports generation.
• Used SQL Server Reporting Services (SSRS) for creating matrix and tabular, drill down, drill through, and parameterized reports based on the requirements.
• CreatedParameterized reports, Cross-Tab reports,Drill down reports& Summary reports by UsingSSRS.
• Developed functionality for On Demand reports like Login Activity, Participation Summary, Top Rewards, PMPM reports, Issuances and Redemptions detailed reports based on clients requirements for clients such as BCBSNC, Eastman Chemical, Kaiser, Motorola etc.
• Worked on the Reports module of the project as a developer on MSSQL Server 2005(usingSSRS, T-SQL, scripts, stored procedures and views).
• Created the Unit Testing scripts and also Extensively Unit Tested all the reports.
• Developed various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
• Scheduled the Reports to run automatically on daily and weekly and also emailing them to director and analysts to be reviewed in Excel Sheet and in pdf format.
• Extensively worked with SQL Server applications like SSIS, Stored Procedures, SQL Querying and T-SQL.
• Developed PL/SQL procedures that will be run as pre-requisites for monthly, quarterly reports.
• Designed and developed Crystal Reports and Business objects reports which includes standard reports, cross-tab reports, summary reports according to the requirements.
• Analyze and Fix SQL queries to resolve the report issues.
• Involved in database backup, recovery procedures.
• Extensively used WEBI, reporter and explorer for querying, reporting and analysis tasks.
• Extensive experience in documenting Universes and reports by using MS Word, MS Excel.
• Train/Mentor a team member, Business User and top level management on Business Objects XI 3.1/XIR2.
• Responsible for writing and executing software System test plans, test scripts and Test cases.
• Performed manual testing and maintain test results for GUI, Regression, Integration and System testing.

Environment: Business Objects Enterprise XI 3.1, Oracle 10g, Windows XP, MS SQL Server 2005/2008, SSIS, SSRS

Confidential, Manhattan, NY

Reports Developer

Responsibilities:

• Involved in requirement analysis, design and development.
• Created Business Objects and crystal reports.
• Involved in universe design, resolving loops, and finding Fan traps, chasm traps.
• Done troubleshooting in database connectivity problems in the various designer components of Crystal Reports.
• Involved in development of complex reports.
• Developed various stored procedures using SQL Server.
• Creating and Formatting the Reports as per the Users Requirements using the features in Business Objects like Master/Detail, Charts, Cross tabs, Slice and Dice, Drill down, @functions to analyze the data.
• Performed unit testing of the reports.

Environment: Business Objects 6.5, Crystal Reports, SQL Server, ASP.NET, VB.NET, ADO.NET, JavaScript, IIS 6.0, VSS 6.0,, XML, XSL, Visual Studio.NET 2003 and Windows XP.

Confidential, Baskin Ridge, NJ

Reports Developer

Responsibilities:

• Involved in analysis, design, development and testing.
• Expertise in developing complex Reports in Crystal Reports using multiple sub reports and drilldown features and using conditional suppression formulas.
• Done troubleshooting in database connectivity problems in the various designer components of Crystal reports.
• Involved in development of complex reports.
• Developed various stored procedures, constraints, indexes and views using SQL server.
• Involved in testing and maintenance of the reports.

Environment: Crystal reports, SQL server 2000, ASP.NET, ADO.NET, XML/XSL, HTML, JavaScript, VisualStudio.NET, IIS

Confidential, Woodland Hills, CA

Software Developer

Responsibilities:

• Analyzing the project scope and functionality.
• Involved in designing the database schema.
• Designing the front- end for the application.
• Developing the modules.
• Generating the reports in Client supplied format.
• Implementing the Change-requests given by client.
• Unit testing the application.

Environment: ASP 3.0, ADO, HTML, JavaScript, MS-Visual Interdev, IIS, SQL Server 7.0,Crystal Reports

Confidential

Software Developer

Responsibilities:

• Involved in Project analysis.
• Contributing in designing the database schema.
• Designing and developing the modules. (Client & Admin).
• Generating the reports in Client Given Format.
• Implementing the Change-requests given by client (if any).
• Unit testing the application.

Environment: ASP 3.0, ADO, HTML, JavaScript, MS-Visual Interdev, IIS, SQL Server 7.0

Confidential

Software Developer

Responsibilities:

• Analyzing the project scope and functionality.
• Involved in designing the database schema.
• Designing the front- end for the application.
• Coding the modules.
• Unit testing the application.

Environment: ASP 3.0, ADO, HTML, JavaScript, MS-Visual Interdev, IIS, SQL Server 7.0