SUMMARY:

• Around 8 years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Servers 2008 R2 and 2012 in Production and Development Environments.
• Proficient in building compelling, interactive dashboards in Tableau and Power BI that answer key business questions.
• Good Conceptual knowledge in .Net Framework 2.0, 3.5 and 4.0.
• Ability to work in all stages of System Development Life Cycle (SDLC).
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, Table Variables and Stored Procedures.
• Hands on experience with performing various SSIS data transformation tasks like Look - ups, Conditional Splits.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2008 R2 and 2012).
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Hands on experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2012
• Experience in Managing Security of SQL Server 2008 R2 and 2012 Databases by creating Database Users, Roles and assigning proper permissions according to the business requirements.
• Experience in developing Dashboard, Ad-hoc and Parameterized Reports, create complex reports (ex: drill down reports using different objects) using SSRS.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Worked extensively on Extraction, Transformation, loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
• Experience in working with Database setup, partitions and maintenance.
• Experienced in Power BI report generation using multiple data sources and custom mapping.
• Extensive experience in Excel with advanced use of formulas, macros, graphs, pivot tables/charts, dashboards/ scorecards and Power BI features.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
• Exposure to designing, developing and maintaining web/windows applications based on .Net.
• Experience in managing large data sets on MS Excel 2013.
• Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Worked with Business Analysts, Web development team, and users on database solutions.

TECHNICAL SKILLS:

Tools: &Packages: SQL Server Management studio, SQLServer Business Intelligent studio (BIDS), DTS, Report Builder 9.0, SharePoint 2007, Team Foundation ServerBI Tools: SSIS, SSAS, SSRS, PowerBI

Databases: MS SQL Server 2008, 2012 MS Access 97/2003/2005/2008.

Language: MDX, C, VB.net, C# (.NET)

Operating Systems: Windows vista/XP/2003/2000, Windows Server 2000/2003/2008, UNIX.

Application Packages: MS Office Suite, MS Outlook, Windows SharePoint Services.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential

SSIS Developer

• Design, document and implement complex ETL extract, transform and load logic as per business requirements to stage data, normalize and integrate it in warehouse.
• Created the functional requirement, technical design, mapping spreadsheet and unit test documents.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Designed and developed mappings, enabling the extract, transport and loading the data into target tables.
• Developed, deployed, and monitored SSIS Packages.
• Optimize performance of ETL using index creation, mapping partitioning, encoding logic, optimizing buffer size and modifying commit intervals in data load.
• Developed Stored Procedures, Packages and Functions.
• Create static and dynamic deployment groups to bundle ETL code and promote it to Test and Production.
• Loaded flat files data into database, database to database and database to flat files using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Designed and developed to extract data from different sources like, Oracle tables, DB2 tables, and Flat files.
• Used script task to write custom code using vb.net to send HTML emails.
• Some involvement with C# and .Net coding used in the script task within the SSIS packages.
• Involved in designing logical data model based on analysis of the requirement and feasibility analysis.
• Design the physical data model based on logical data model, query performance and source data size.
• Analyze and profile the source data flowing into these tables for making the design decisions.
• Design the ETL specifications sheet based on the rules in the data model.
• Developed Unit Test Cases and document them as per Project standards.
• Test data integrity among various sources, targets and variousperformance issues.
• Troubleshoot problems by checking sessions and workflow logs.
• Extensively worked on debugging the programs for data quality issues and job failures.
• Overnight batch processing using UC4. I assisted in adding client’s customized batch processes.

Confidential, St. Louis

MS BI Developer

• Developing Stored Procedures and Functions used for inserting, updating, or transforming data.
• Developing complex T-SQL queries used for data investigation.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Developed SSIS packages with various tasks like - for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task.
• Creating SSIS packages for transforming data from OLTP DB to warehouse, to import data from source systems, or transfer data from one server to another.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS .
• Created new reports from the scratch for new requirement and modifies some of the existing reports using SSRS.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Provided documentation of reports and the development process to support the system.
• Fine-tuned SSRS reports, SSIS packages and stored procedures that take long time for execution.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created requirement documents, technical design documents and knowledge sharing documents.
• Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Developed chart reports, parameterized reports, drill down report, drill through report, matrix report and master detail reports.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using PowerPivot, power Query, power view and power BI.
• Expert on creating multiple kind of power BI Reports and Dashboards.
• Created stored procedure to be consumed by Excel dashboard and Power BI dashboard.
• Responsible for creating SQL datasets for Power BI and Ad-hoc reports.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.

Confidential

MS BI Developer

• Actively involved in the complete software development life cycle for a design of database for new Financial Accounting System.
• Used MS SQL Server 2008 R2 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management, data center services, system events support and billing.
• Stored Procedures and Functions were optimized to handle major business crucial calculations.
• Set up SQL Profiler to trace various Database activities, application Responses and Performance tune them.
• Implementation of data collection and transformation between different heterogeneous sources such as flat file, Excel and SQL Server 2008 R2 using SSIS, BCP and Bulk Insert.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Documented the database design and developed data dictionary for databases.
• Managed the historical data in the data warehouse from various data sources.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.

Confidential , Jersey City, NJ

MS BI Developer

• Conducted detailed analysis and reporting functions to ensure complete accuracy.
• Created analytics for various functions according to data quality and latest trends.
• Developed T-SQL packages, pivot tables and MS SQL reporting services reports.
• Implemented procedures for integration and customization of share point dashboards with graphs and charts.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activitiessuch as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Participated in learning and updating of business processes, functional relationships and information usage.
• Coordinated with business partners for identification of improvement opportunities.
• Collaborated with data warehouse team members in designing of data marts along with reporting.

Confidential

Jr. SQL Developer

• Developed T-SQL Queries, Triggers, Functions and Stored Procedures.
• Used SQL Analyzer and Profiler analyzing the SQL statements and procedures.
• Created Schema Objects such as tables, views, maintained referential integrity and granted roles to the Users.
• Created views to restrict access to data in a table for security.
• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.