SUMMARY

• Over 9 years of IT Professional experience in Development, Client Analysis, Database Design and Expertise in system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experience in installing, configuring, managing, monitoring, securing and troubleshooting SQL Server 2014/2012.
• Expert with Transact - SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Expert in utilizing ETL tools for data loads, database integration/conversions, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
• Expertise in DDL Scripts for generating Tables, Views and Functions.
• Expertise in Scripting ANSI T-SQL Queries, Complex Stored Procedures, User defined functions and Indexes.
• Good understanding and experience in features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Efficiently used regular expressions in ANSI SQL querying.
• Implemented different types of constraints on tables.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered and Non-clustered Indexes.
• Extensive experience in debugging SQL Server stored procedures/triggers and T-SQL.
• Worked with improving the performance on SQL, TSQL and provided the recommendation on server related tuning issues.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Expertise in MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Experience in Creating SSIS Packages to automate the Import and Export Wizard of data to and from SQL Server 2014.
• Experience in enhancing and deploying the SSIS Packages from development server to production server, creating SSIS packages.
• Expert in building various DTS packages with ActiveX scripting for transferred data modifications and migrated various DTS 2000 packages to SSIS packages.
• Knowledge of developing ETL routines to integrate data from disparate data sources including relational databases, flat files, office documents, OLE DB Source, Excel Spreadsheets.
• Thorough Knowledge of various SSIS Objects such as Dataflow Components, Control Flow Elements, Connection Managers, Runtime Events, Log Providers etc.
• Implemented error handling and roll back process in ETL load.
• Experience in managing various SSIS Package Configurations in the form of XML Files.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2012.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Developed Dashboard Reports using SSRS, Report Model and Ad Hoc Reporting using Report Builder.
• Provided 24x7 support and trouble shoot production issues on high availability systems
• Experience in Data Warehousing and analysis skills: ETL tools, MDX, OLTP, and OLAP Cubes.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST, UA/UT, and Production.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Knowledge in Oracle 9i/10g database.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team
• Experience in Various SSIS Azure feature Tasks like Azure Blob Download, Azure Blob Upload, Azure HD Insight.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team

TECHNICAL SKILLS

Languages: C#.Net, VB.Net, C, C++, T-SQL, SQL, PL/SQL, VB6.0

RDBMS: SQL Server 2014/2012/2008, Oracle 9i/10g and MS Access 2000/97

Web Technologies: ASP.Net, ADO.Net, HTML, DHTML, JSP, XML, AJAX, CSS, XML, XSL, XSLT, Web Services, WSDL, WCF,WPF, Silverlight

ETL Tools: SSIS(SQL Server Integration Services), DTS (Data Transformation Services) MS Visual Studio 2012/2014

Scripting Languages: JavaScript, VBScript

Database Tools: MS DTS, MS Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Backup Server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, Replication Tools, SSAS (SQLServer Analysis Services), SSRS (SQL Server Reporting Services).

Operating Systems: Windows XP/Advance/2000/NT

Software Application: Visual Studio .Net, Dreamweaver, ER-Studio

Reports Tools: SQL Server Reporting Services (SSRS), Crystal Reports

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Pine brook, NJ

SR BI Developer/Technical lead

Responsibilities:

• Worked closely with the business Analyst for understanding the requirement and involved in planning and designing data based on business requirements.
• Design and Development of ETLs and automate the GSP revenue Recognition and Reconciliation Automation.
• Worked closely with senior Business analysts for Month End Revenue Recognition and Journal Creation.
• Deployed SSIS packages as a scheduled job in Prod test and Prod to automate the process
• Design and development of Finance Database to automate the GSP Operations
• Creation of Clustered and Non Clustered Indexes, Optimizing the Queries and Stored Procedures to run the Queries Fast.
• Optimized the Data Retrieval process from High volume Tables.
• Designed and Integrated the Batch Process to audit the Revenue Recognition Process daily and Monthly.
• Automated the Variance Management Hub Billing System Process by deploying the ETLs to Prod Test and Prod
• Analyzed the Business logic for Transportation cost Reconciliation and Automated several Reports by scheduling the ETLs on Daily basis
• Install and configure IBMCognos10.2.1 software on servers (multiple environments).
• Set up Data Level and Object Level Security in Framework Manager using macros.
• ManageCognosmetadata, Folder structure and utilizeCognos10.2 advanced features.
• Responsible for implementing best practices onCognosDashboards, Scorecards, Portal, report design, development and testing.
• Implementation of strong SDLC Process during the Design, test and Development Process.
• Developed Various Script Tasks using C# in SSIS packages to implement the complex Data Retrieval form various different sources.
• Enhanced the Scheduling of SQL Jobs in Prod test and Prod to decrease the complexity of Auditing
• Worked with Various Business Ecommerce groups to automate the business logic from Excel to SQL 2012.
• Supported various different developments, Enhancement tasks for the purpose of automation.
• Wrote complex ANSI SQL queries using joins, sub queries and correlated sub queries for creating SSIS Packages.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSIS.
• Documented and prepared project status report updates and audit reports.
• Maintained and Supported generation of various reports in PDF
• Used custom .NET assemblies for Script Task in SSIS.
• Extracting Data from multiple databases using Linked Server.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Reduced Run time for the ETLs by Using the Efficient Components in The SSIS Packages.
• Involved in Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Setting Up Environment for QA Team To Work on their test cases
• CreatedPowerBIreport Such as 'Daily Sales and order Report', 'Invoiced Sales Report', 'Daily Sales Report', 'Territory Performance Report'.
• Designed dashboards utilizingPowerBIbased on separate report listed above.
• Created KPIs utilizing calculated function and quick table function in tableau and DAX inPowerBI.
• Optimized report data sets to reduce the report generation and rendering time inPowerBI environment.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front-end application usingSSAS.
• Responsible for maintaining cubes usingSSASand populate the cubes with the data.
• Migrated and translate legacy reports intoPowerBIfrom SSRS environment.
• Designed dashboards and scorecards withpowerpivot for analytical decisions inPowerBIdesktop.
• Involved in testing, bug fixing and documentation for the project. Migrated data from SQL and solved related issues. Created complex DTS Packages for Data Migration and Transformation.
• Organize the ETL’s Based on dependency with others. Active Research in Maintenance of the ETL’s after deployment in Production.
• Involved in design and developing Web Forms in ASP.NET using C# and VB.net
• Participated in gathering and documenting User Requirements
• Designed different components using C# language for enterprise-level web applications built on 3-tier architecture with extensive use of Object Oriented Programming Techniques
• All the user interface layers, web pages are created and integrated to maintain the performance of data flow and data integrity using ASP.NET User Controls, Web Server Controls and ADO.NET
• Involved in the design of security module that gives access to users based on the roles

Environment: Microsoft SQL Server 2012, SQL Server Data Tools, Visual Studio 2010, .Net Frame Work 4.0/3/5/2.0, C#, MS Visio 2013, MS Project 2013, Visual Studio 2012/2014,MS Excel, MS PowerPoint, MS Power BI, SSAS,SSIS,SSRS.

Confidential, Addison, TX

Sr Software Developer

Responsibilities:

• Worked closely with the business Analyst for understanding the requirement and also involved in planning and designing data based on business requirements.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS)
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension (SCD), Data Conversion, OLE DB command, Union All, Flat file Source, Flat file Destination, Conditional Split and more. Performed ETL mappings using MS SQL Server Integration Services
• Wrote complex ANSI SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Created package dependencies by calling Child packages within Parent.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeeded.
• Developed dashboards withPower BIwhich display key KPIs for business analysis and decision-making.
• Configured Report Server in native mode to support report deployment and scheduling.
• Scheduled SSRS reports with standard/data-driven subscriptions in report manager.
• Configured the cloud databases for HA solutions with Geo-replication.
• Delivered business oriented reports with subscriptions inPowerBIservices.
• Design scorecards and different dashboards with slicers utilizingPowerBI.
• ImplementedPowerBIPowerPivot for data analysis by developing various aggregation and calculations.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets forPowerBI.
• ImplementedPowerBIgateway different source to matching analysis criteria and further modeling forPowerPivot andPowerView.
• Successfully deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Created stylish report layouts using global expressions, functions, subtotals, sorting the data using SSRS.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, parameterized and cascading parameterized reports using SSRS.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS)
• Designed, built the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Developed Multi-Dimensional Expression (MDX) queries to analyze data from SSAS cubes
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2012 (SSAS)
• Experience in generating On-demand and Scheduled Reports for business analysis or Management decision using SQL Server Reporting Services.
• Created jobs using SQL Server Agent and scheduled them to execute the SSIS Packages on a predefined time interval by the business.
• Created Linked reports, Ad-hoc reports based on the requirement.
• Documented all the project work in support for maintenance
• Maintained Version Control Scripts in TFS For SQL Scripts and SSIS Packages.
• Created/edited job module in SQL Agent in development and participated in production deployment.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc
• Used custom .NET assemblies for Script Task in SSIS.
• Extracting Data from multiple databases using Linked Server.
• Expertise Knowledge In Calling Commands From SSIS to DB2.
• Involved In Request For Changes in Production As per The Request of Business.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Maximized The Performance of Queries By Active Monitoring and Creating Indexes to Objects.
• Reduced Run time for the ETLs by Using the Efficient Components in The SSIS Packages.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created report models and deployed on report server.
• Involved in Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Setting Up Environment for QA Team To Work on their test cases
• Used Environment variable in SQL server 2012 to connect to different servers.
• Involved in testing, bug fixing and documentation for the project. Migrated data from SQL and solved related issues. Created complex DTS Packages for Data Migration and Transformation.
• Responsible for the development using ASP.NET and C# as the server side coding language and some designing issues and implementation
• Used ADO.Net connectivity to an SQL Server database
• Developed various user controls for different requirements
• Used Grid View Control for data editing and display purposes
• Cookie development for validation, and other site requirements

Environment: SQL Server 2014/20012/2008 R2 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), MS SQL Profiler, SQL Query Analyzer, Visual Studio 2008/2012, Windows XP, MS Office 2003/2007/2010, MS Access MS PowerPoint, MS Power BI, SSAS,SSIS,SSRS.

Confidential, THOUSAND OAKS, CA

SQL BI Developer

Responsibilities:

• Gathering the requirements and performing feasibility analysis based on business requirements.
• Identify data Issues by Performing Data Analysis and reporting back to business to solve the Business need.
• Design the Data Flow diagrams in Microsoft Visio Based on the Feasibility Study that went in the requirements and Feasibility Analysis Phase.
• Design and analyze The Dimension and Fact Tables based on Star Schema Data model.
• Created Physical, Logical data Model in E-R Studio. Defining columns, Keys and Structure of Physical Objects and defining relationship between the Objects.
• Creating Dimension and Fact Tables based on the Logical Design in the E-R Studio in SQL Server 2012 R2 management Studio.
• Analyze the data Flow between the Dimension and Fact tables from the Source Data.
• Created Clustered and Non Clustered Indexes on the columns for dim and Fact Tables where complex joins are performed.
• Develop the SSIS Package which Populate dimension and Fact Tables from the Source data.
• Assign Dynamic Variables to the SSIS packages and populate the ETL Using the Variables in the database.
• Populate the Database Connections Dynamically using the environment variable which picks up the connection string from database tables.
• Flag the Duplicates, Redirect error rows and Duplicates to the Reject Tables. Alert the Business on the Rejected rows.
• Used complex Queries to Merge the data into dimension tables based on the batch numbers and Business logic Provided.
• Update the Dimension Tables and redirect the History rows to the History Tables.
• Used Complex joins, functions, CTE, user defined functions, stored procedures and ad-hoc queries in SSIS to Populate the Fact and Dimension Tables.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Alert The Business on the Data Quality issues and status the jobs.
• Optimize the Queries, Stored procedures after checking the Execution Plan in the Management Studio.
• Perform Unit Testing to each and every query in SQL, SSIS Component.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Audit the Batch using the Run Identification number for each and every row.
• Create the SQL Scripts in order to deploy the ETL in DEV, UAT and Production.
• Create the Run Book Document to Keep track of the Issues that are part of the ETL or Database.
• Organize the ETL’s Based on dependency with others. Active Research in Maintenance of the ETL’s after deployment in Production.
• Provide the Scripts to UAT to query the data in database in order to perform Validation of Sales.
• Revised monthly performance reports, eliminating redundancies in Dimension and Fact Tables.

Environment: SSIS, SQL 2014/2012, TFS, VB.Net. Windows 2008, MS Excel, Visual Studio 2012, COGNOS, E-R Studio, Microsoft Visio.

Confidential, Simi Valley, CA

SQL, SSIS, SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation in order to Complete BRD, HLD Documentation.
• Optimized the performance of various SQL scripts, stored procedures by Implementing Complex business logic with User-Defined-Functions, Indexes, Views and also created User Defined Data types, Clustered & Non-clustered Indexes.
• Performed feasibility studies and estimated the implementation of new or revised database systems to solve business needs
• Create new database users, control and monitor roles and user access privileges to the database maintaining system security
• Designed Fact tables, Dimension tables, scheduled transfer data from real time database to data warehouse and databases
• Analyze business and technical requirements, as well as data warehouse data models (SSIS, SSAS SSRS, SQL) to understand the detailed data management requirements
• Responsible to analyze the performance of the system and generate monthly performance metrics
• Responsible to complete the root cause analysis for any performance/data issues and generate the reports for data analysis.
• Identify Data issues by intensive data analysis of client legacy data using automated SQL scripts and dynamic SQL, PL/SQL stored procedures, cursors, loops and documented the processes.
• Used complex T-SQL queries for data Extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, stored procedures and ad-hoc queries.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2014/2008/2012 Analysis Services (SSAS) and Reporting service (SSRS) use of SSAS Cubes and Best Practices for Implementation of Reporting Services Administration
• Used Batch Files to Import Data from other Data Base.
• Created and maintained logins, roles and permissions on the .Net Web pages and provided required privileges according to the user’s requirements using .Net 4.0.
• Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
• Extensive experience in writing queries by using joins, Indexes, views, Stored Procedures and Triggers in SQL Server Management studio (SSMS).
• Filtered Invalid data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Extracted data From Complex Flat Files into SQL using SSIS.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.

Environment: C#, Asp.Net, SSIS, SQL 2012/2008 R2, TFS, DB2, VB.Net. Windows 2008, MS Excel, Visual Studio 2012

Confidential, Denver, CO

SQL BI Developer

Responsibilities:

• Involved working on Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, joins and User-defined functions.
• Created and executed SQL validation scripts, and analysis scenarios to test the functionality of the SSIS ETL data suite, ETL validation rules and transformations
• Worked on Aggregate, financial and Date time in Development of reports.
• Developed cursors to rebuild indexes on all tables.
• Performed data flow checks from various marts and column mappings thoroughly.
• Analyze data for integrity and write test cases to help testing Team.
• Created, developed, maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/SSMS on SQL Server 2012 environment and scheduled the jobs to do these tasks periodically.
• Worked with SSIS Client tools - Control Flow, Data Flow, Event Handlers, and Package Explorer.
• Created Mapping to Extract Data from different Sources and load into different Targets
• Followed SSIS recommended Standards and Best Practices to improve Performance of ETL mappings.
• Supporting on-boarding and training of Business Objects Power Users using Web Intelligence and other Business Objects tools
• Extracted and reviewed data from OLTP to OLAP using SQL Server Integration Services (SSIS) 2014
• Implemented cursors in some business situations to get reports for Production Analysis.
• Involved in Backup and recovery of Master, MSDB and Application databases.
• Responsible for Query optimization and Performance tuning using SQL Server Profiler.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.

Environment: C#, ASP.NET 2.0, IIS 5.1, Java Script, Crystal Reports, VSS, XML, Web services, Visual Studio 2014, SQL Server 2000 and Visual Source Safe.

Confidential

SQL Developer

Responsibilities:

• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Tested the Installation of SQL Server and implemented different security modes.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Upgrading from SQL Server 7.0 to SQL Server 2000.
• Created Snapshots, Subscriptions and Transactions using Replication services.
• Developed database monitoring and tuning strategies.
• Tuned Complex SQL Queries.
• Maintain Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, locks and performance of SQL Server.
• Created packages using DTS for moving data from MS Access to SQL Server and vice versa.
• Assign permission to user(s), role(s), and object. Support column level permission.
• Wrote and integrated Stored Procedures to generate the Reports.

Environment: C#.NET, ADO.NET, IIS 5.0, HTML, CSS, DHTML, JavaScript, SQL Server.