SUMMARY

• Extensive programming experience as Database & Report Developer in Microsoft SQL Server 2005/2008/2012 using T - SQL and Business Intelligence Data Tools and various platforms.
• Good experience in Design, Development, Implementation and Testing of Database systems using MS SQL Server 2005/2008/2012 DDL, DML, DRL and DCL commands for various Data Warehouse and business applications.
• Worked with databases like SQL Server 2005/2008/2012 and Expert in MS Office 2010.
• Experience in writing Complex T-SQL Queries, Dynamic Queries, Sub-queries, Complex Joins.
• Extensive experience in Database design using SQL, T-SQL in Stored Procedures, Views, Functions, Constraints (Primary Key, Foreign Key), Triggers, Indexes and Batch Scripts.
• Have used TFS 2010 to support agile development practices to produce quality software.
• Experience in Performance Tuning and Query Optimization and reviewed various stored procedures with options, Function and T-SQL code and
• Good knowledge in Data Warehousing methodologies and ETL Process.
• Expert in Extraction, Transformation, and Loading (ETL) data from various data sources using SSIS. Created packages to extract data from Oracle, Flat file and load into MSSQL.
• In SSIS I have worked with Lookups, Slowly Changing Dimensions, Fuzzy Lookup, Web Services, and Container and used that in Reporting Service (SSRS).
• Developed reports on SSRS on SQL Server ( 2005/2008/2012 ). Understanding of SSAS.
• Used SSRS and created Table Report, adding calculated Values, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Created reports that has been defined by Business Objects and generated Crystal reports.
• Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Expertise with job scheduling using SQL Server Agent to perform updates on completion of jobs inserted.
• Build, Deployed and Published the Reports to Report Manager Website. Have worked with XML and Web Services.
• Programming knowledge in .NET and to connect the .NET front end with Microsoft SQL Server Management Studio and Retrieve data and Rich knowledge in technologies like Asp.net, C#, Ado.net
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Experienced in all stages of software lifecycle - Requirements gathering, Design, Development and Deployment.
• Strong ability to share knowledge with others and collaborate as part of a team to achieve positive outcomes with good communication skills.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2005/2008/2012 , Mongo DB

Languages: T-SQL, ASP.NET, C#.NET, VB.NET,MVC, OPENXMLSDK, JAVASCRIPT

Tools: Microsoft SQL Server Management Studio, SQL Server Data Tools, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio and MS Visio.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Report Manager, Report Builder, MS Excel,Tableau.

PROFESSIONAL EXPERIENCE

Confidential, PA

SR. BI Developer

Responsibilities:

• Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound/Outbound Benefits Enrollment and maintenance files (834 HIPAA).
• Involved in analyzing different modules EDI interfaces to understand the source system and source data
• Created a SSRS Report to generate the 1095A form for the Year 2015.
• Designed and developed mappings to load the data from flat file to SQL Server tables for reporting purposes
• Developed stored procedures and views for data import and manipulation
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance, an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Generated and consolidated reports forecast exposure comparison with SQL Reporting Services.
• Worked on SSIS, for remove duplicate records with data standardization
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Designed several tabular & Matrix reports in SSRS with dynamic grouping and dynamic filters.
• Generated periodic reports, charts based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Experienced in creating Drill down and Drill through reports by defining the parameters in SSRS.
• Developing SSRS reports for publishing the data to end users.
• Efficiently carried out DBA responsibilities in planning DB2 version migration activities, in migration phases and in performing post migration tasks
• Held Oracle DBA responsibility for parallel Oracle/SAP database using Oracle Parallel Server
• Reviewed the logical model with Business users, ETL Team, DBA’s and testing team to provide information about the data model and business requirements.
• Used various types of reports layout options like charts (bars, lines, pie etc.….), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Formatted the reports using Global Variables and expressions.
• Responsible for creating the Complex Crystal Reports On demand, Ad Hoc Reports, Frequency Reports, Summary Reports, Sub Reports, Drill-down, Dynamic grouping, Cross-Tab, graphical, aging reports
• Designed dashboards on the concept of Dynamic Availability where in avariety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Revenue Impact Analysis,Inventory Control, Pricing Opportunity Analysis, Markets Overview,Shopping Activity, etc., in the developed dashboards using Tableau
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Created histograms, pie charts, box plots, scatter plots for inventor management, background maps illustrating the potential revenue change destinations flown across different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units using Tableau.
• Jobs were scheduled using Batch files and Cybernation Automation Scheduler
• Working on performance tuning of developed code and providing QA and UAT support for promoted codes
• Maintain documents for Design reviews, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans
• Developed a number of complex ETL Mappings, Mapp lets and Reusable transformations for data loads that follow the user requirements and business rules.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Manager, T-SQL.

Confidential, Hanover, NH

Team Lead (SQL, SSRS, SSIS, ASP.NET)

Responsibilities:

• Determined the duties and responsibilities of individuals in a team.
• Analyzed the individual performance of each team member and motivated them to perform even better.
• Organized workshops to improve the performance of the members who were lagging behind in terms of performance.
• Set goals and motivate the team in achieving them
• Assign and get tasks done by the team in a timely manner
• Develop strategy and motivate team to follow them.
• Created complex Stored Procedures, functions, views, and other SQL Joins for application using T-SQL
• Performance tuning of long running queries by replacing cursors with various joins, common table expression (CTE)and indexing.
• Created Simple Web forms using asp.net for the users to view the status of the jobs submitted by them.
• Worked with development teams in the design of physical database and in modification.
• Experience in writing T-SQL scripts, dynamic SQL, Constraints, relational database models, data dictionary and data integrity.
• Designed and developed interactive dashboards.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Developed multiple reports using SSIS and SSRS.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Performed the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions; Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
• Created Parameter driven reports to running time and restrict volume of dat
• Created numerous ad-hoc and canned Reports using SSRS.
• Designed and developed matrix and tabular report with drill down, drill through and drop down menu option.
• Scheduled and maintained routine jobs, tasks, and alerts. For instance, an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Generated and consolidated reports forecast exposure comparison with SQL Reporting Services.
• Implemented various reports for the migration to SSRS.
• Knowledge in creatingBasic Table Report, adding calculated Values, Using Document Maps, Tablix Report, Adding Sub report to Parent Report, Reports with Interactive Navigation, and Display data in Various Formats.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Use prompts, alerts, drill down analysis as per the end user requirements
• Create nested, conditional subgroups and formatting features in reports
• Create Sub reports called from the main report to implement the business logic
• Involved in post deployment and maintenance of reports.
• Developed ETL framework to extract and load the data from multiple database from SQL Server 2008 to File Server.
• ConfiguredXMLconfigfiles (. dtsconfig files) to change properties of packages dynamically.
• Created reports for policyholders by usingExcel pivot tableand SQL server Reporting service (SSRS).
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Developed complex SQL, PL/SQL Testing scripts of the data warehouse application.
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Analyzing the AS-IS system which loads the Monthly/Weekly/daily multi source data files for Data mart
• Used various types of reports layout options like charts (bars, lines, pie etc.….), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Formatted the reports using Global Variables and expressions.
• Experience in deploying the created Reports in various sources like Web Browser and XML.
• Understands the complex processing needs of big data and has experience developing codes and modules to address those needs.
• Performed problem-solving in a big data arena.
• Productized cloud and big data services and solutions - spur and promote incremental adoption of new technologies.
• Solved many complex issues like “File Upload Control-Upload size limit”.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Manager, T-SQL.

Confidential, Sunnyvale, CA

Developer (SQL, SSIS, JAVASCRIPT, ASP.NET)

Responsibilities:

• Full SDLC development of an address cleansing, name cleansing and enterprise individual/customer identification system utilizing Quality Stage for cleansing and standardization.
• Performed the analysis and feasibility requirements.
• Created Stored Procedures, and other SQL queries for application using T-SQL
• Designed and developed interactive dashboards that enabled analysts to check various analytical systems.
• Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
• Written code to extract data from the Cosmos data center using Scope on the system, C#, batch files, T-SQL for the MSN NIF pipeline, aggregate data for forwarding to internal teams. Configure and host Malevich site for efficient code review process.
• Fully database configurable distributed multithreaded Windows service to copy large log files from MSN log servers, process them as needed and insert them into a distributed file system cluster (Cosmos)
• ConfiguredXMLconfigfiles (. dtsconfig files) to change properties of packages dynamically.
• Developed webpages with client side scripting and client side validations using JavaScript.
• Implemented the Master Child Package Model for easier maintenance and better performance of SSIS Packages.
• Scheduled and maintained job to check for the status of analyst servers.
• Involved in database design.
• Involved in creating SSIS Package with proper control follows and data flow to check which servers are available for analysts to perform analysis.
• Scheduled Job in SqlServer agent for every 2 min to check availability of systems and updates the user who is using the system in database.
• Performed Unit, System Testing and created several Test Cases to validate the data from reports.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Manager, T-SQL.

Confidential, Edison, NJ

BI Developer (SQL, SSIS, SSRS,ASP.NET, OPENXMLSDK)

Responsibilities:

• Full SDLC development of an address cleansing, name cleansing and enterprise individual/customer identification system utilizing Quality Stage for cleansing and standardization.
• Performed the analysis and feasibility requirements.
• Created Stored Procedures, and other SQL queries for application using T-SQL
• Designed and developed interactive dashboards that enabled analysts to check various analytical systems.
• Created Web services using Asp.net.
• Customized existing Reports anddeveloped new Reports to suit client requirements.
• Modified the rendered excel report format by updating the string fields to numeric fields so that the calculations can be done very fast
• Created simple web forms for getting the information from users to generate the reports.
• Created SSIS Packages with ScriptTaskComponent to get all the calculated data to be written into excel file so that comparison of the values will be easier with xml language. When rendering to excel from SSRS some decimal value fields are getting converted to text fields which makes gives variation in the premium values.
• Created the Excelworksheets by using xmlsdk to ensure that the file is written in xml format so that the data is read as XmlNodes.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Integration Services (SSIS), T-SQL.

Confidential

Developer (SQL, SSRS, ASP.NET)

Responsibilities:

• Created complex Stored Procedures, functions and other SQL Joins for application using T-SQL
• Created Simple Web forms using asp.net for the users to view the status of the jobs submitted by them.
• Designed and developed interactive dashboards that enabled stakeholders to focus on performance drivers.
• Developed multiple reports using SSIS and SSRS.
• Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
• Created numerous ad-hoc and canned Reports using SSRS.
• Designed and developed matrix and tabular report with drill down, drill through and drop down menu option.
• Generated and consolidated monthly reports to drive forecast production plan with SQL Reporting Services.
• Implemented security for the reports, user tabs, report models and folders in the report manager at the application, database and the report manager level.
• Proficient in analyzing the end user requirements and converting them into efficient Technical design and technical code documents.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production
• Implemented various reports for the migration to SSRS.
• Knowledge in creatingBasic Table Report, adding calculated Values, Using Document Maps, and Tablix Report, Adding Sub report to Parent Report.
• Involved in post deployment and maintenance of reports.
• ConfiguredXMLconfigfiles (. dtsconfig files) to change properties of packages dynamically.
• Used various types of reports layout options like charts (bars, lines, pie etc.….), images, graphs, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Formatted the reports using Global Variables and expressions.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Report Manager, T-SQL, Microsoft VisualStudio-2008.

Confidential

SQLDeveloper (SQL, JAVASCRIPT, ASP.NET, SSRS)

Responsibilities:

• Performed the analysis and feasibility requirements.
• Created Stored Procedures, and other SQL queries for application using T-SQL
• Designed and developed interactive dashboards that enabled analysts to check various analytical systems.
• Experience with creating complex SSIS Package using proper control and data flow elements with error handling.
• ConfiguredXMLconfigfiles (. dtsconfig files) to change properties of packages dynamically.
• Developed webpages with client side scripting using JavaScript.
• Involved in database design.
• Performed Unit, System Testing and created several Test Cases to validate the data from reports.

Environment: Microsoft SQL Server 2008/2012 SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Report Manager, T-SQL, Microsoft VisualStudio-2008.

Confidential

Developer (C#, SQL)

Responsibilities:

• Performed the physical database analysis and feasibility requirements.
• Created basic form in C# and connect it to the SQL Server Management Studio.
• Full SDLC development of an address cleansing, name cleansing and enterprise individual/customer identification system utilizing Quality Stage for cleansing and standardization.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Database planning resulting from database requirements. Designed capacity, security, performance, backup and recovery planning.
• Optimized the performance of queries with modifications inT-SQL queries,removed unnecessary columns, and eliminated redundant and inconsistent data.
• Expert in writing StoredProcedures, Functions,ad hoc queries,UDF,Common Table Expressions (CTEs) to facilitate efficient data manipulation and data consistency using SQL Server Management Studio.
• Used UML for Design and Documentation.
• Performed SQL Performance tuning on Queries and used Join Hints, Clustered Index and improved the performance of queries.
• Physical Implementation of database into SQL Server 2005 using T-SQL.
• Performed Unit, System Testing and created several Test Cases to validate the data.

Environment: Microsoft SQL Server 2008 SQL Server Management Studio, Microsoft VisualStudio-2008, T-SQL.