PROFESSIONAL SUMMARY:

• Over 9+ years of strong experience in the IT industry as a MS SQL Server 2016/2014/2012/2008/2005 Developer/BI Developer in various domains like Immigration, Financial, Healthcare and Banking.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, and MS Access.
• Extensive experience working with BCP, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/Sybase databases.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2016/2010/2008/2005.
• Experience in creating and updating clustered and non-clustered indexes to keep up the SQL Server Performance.
• Experience in analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Expert in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Very good understanding of Dimensional modeling with Star Schema and Snowflake Schemas.
• Extensive knowledge in Business Objects. This includes experience with Designer, Web Intelligence Rich Client, InfoView, Crystal Reports, Business View Manager… etc.
• Extensive experience in building Universes and retrieving data using Universes, Personal data files, stored procedures, Free hand SQL and creating complex ad-hoc Reports using Business Objects reporting tools.
• Involved in end users, business users and customers on how to create modify WEBI reports and Crystal reports.
• Expert in Creating Report using SAP 4.1 Business Object Crystal Reports 2008/2013 and Web Intelligence.
• Experience in Creating universe using SAP 4.1 Business Objects Tool Universe Design Tool (UDT) and Information Design Tool (IDT).
• Efficient in up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008.
• Strong hands on experience implementing dash boarding, data visualization and analytics using Tableau Desktop and Server.
• Good experience in dashboard designing with large data volumes from various data sources.
• Maintained positive communications and working relationships at all business levels.

BUSINESS/TECHNICAL SKILLS:

MS SQL Server 2016/2014/2012/2008 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SAP Business Objects, Crystal Reports, Web Intelligence, BCP, SQL Profiler, Enterprise Manager, Management Studio, Microsoft Access 2000, ERWIN 4.0/4.1/4.2/7.2 , Microsoft Visio 10.0/11.0, T-SQL, C#, VB.Net, XML, Oracle 9i/10g,Team Foundation Server 2010,Visual Source Safe 2005, MS Office 2013/2010/2007/2003 , Windows 2010/2007/2003/2000 Advanced Server/Professional

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

BI Developer/ MS SQL Developer

Responsibilities:

• Subject matter expert for Enrollment process, Student Testing and District ID Process. Created all new lines of products using SSIS and SSRS
• Involved in the complete SDLC including requirement specifications, Analysis, Design, Development, Testing and worked on End-to-End Process (starting from requirements analysis to implementation)
• Standardized and documented the process flows for developers to provide a base guideline and a better understanding of the functionality.
• Involved in Specification review and Code review for batter implementation and code performance.
• Designed, implemented & maintained over 200 SSIS Packages. And automated them using SQL Agent and Control-M.
• Experienced in upgrading SSIS packages from VS2012 to VS2015.
• Developed new interfaces (SSIS Packages) using various SSIS transformations like split/merge/union, Lookup, Fuzzy grouping, Row count, SCD Transformations.
• Implemented checkpoints and error handling using Event handler.
• Developed new reports based on technical specifications created using Reporting Services (SSRS).
• Implemented complex business logic using SQL server stored procedures/functions/triggers.
• Provided production support for MiSiS project on interfaces (using SSIS) and reports (using SSRS).
• Worked on production deployment for new interface/reports developed per various MiSiS milestone releases.
• Created a deployment utility for SSIS and automated for each environment (Dev/QA/Prod).
• Maintained ongoing reports/interface programs and assist users with data request/correction as required.
• Handled performance optimizations to existing/new implementation using DMVs, indexes and statistics.
• Worked with application team to design front-end screen for users and provided database support in designing and implementing new data models that worked best for the application.
• Participate in meetings with users regarding modifications to existing systems, methods, forms, records, and reports

Tools: MS SQL Server 2016/2012, MS Business Intelligence Studio 2015/2012/2010 , Team Foundation Server (TFS), Control-M.

Confidential, Matawan, NJ

MS SQL Developer / BI Developer

Responsibilities:

• Participating in meetings with business users to gather the requirements and to identify the business needs.
• Created database objects like table, Views, Store Procedure, Triggers, Functions etc.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler, Sentry one plan explorer and Index Tuning Wizard in SSIS.
• Created jobs on daily basis using SQL Server Agent jobs.
• Migrated data from various sources like Excel, text, CSV, XML file into SQL database as per business need.
• Developed and deploy SSIS packages from Staging to work and from Work to Certified database using Derived Columns, Conditional Split, Script components, Script Task.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Foreach Loop container to extract data from different databases dynamically.
• Used C# and VB.net using Script task and Script Components in SSIS.
• Generated flat files, Excel files and CSV files dynamically using SSIS.
• Performed ETL Mapping using MS SQL Server Integration Services.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Create various report using Crystal Reports and Web Intelligence.
• Provide support to internal finance team to get custom report according to their needs
• Trained the Finance user in making use of universe to create and publish ad-hoc reports.
• Set up groups and users for Business Objects deployment. Managed user profiles using CMC.
• Created LOV’s (List of Value) in Business View Manager.
• Involved in the designing and Building of Universes, Classes and objects.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Exported universes to Repository to make universe available to the users.
• Created reports using the Universes and Free hand SQL as Data providers.
• Created User Objects including Dimensions, Details and Measures.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops/Ambiguities and checked the Integrity of the Universes.
• Build and published customized interactive reports and dashboards from scratch
• Scheduled report and data extracts using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Worked closely with offshore team in India on a day to day basis for the report conversion project.
• Responsible for leading offshore team on providing technical guidelines and business logic.

Environment: MS SQL Server 2008/2012/2014/2016 , MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), BIDS, SAP Business Objects, Crystal Reports 2013, Web Intelligence, InfoView, Central Management Console ( CMC), Visual Studio 2010/2012/2013/2015 , MS-Access, VSS 2008, C#, VB.net, Microsoft .NET framework 3.5, TFS, Tableau 9/10, Sentry one, Royal TS

Confidential, Solon, OH

MS SQL Developer / BI Developer

Responsibilities:

• Participating in meetings with business users to gather the requirements and to identify the business needs.
• Interacted with business users and collect the required information (BRD) for developing Business Rules Document which would become the basis for the Intake Automation Process.
• Created database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created jobs on daily basis using SQL Server Agent jobs.
• Migrated data from various sources like Excel, text, CSV file into SQL database as per business need.
• Developed and deploy SSIS packages from Staging to work and from Work to Certified database using Derived Columns, Conditional Split, Script components, Script Task.
• Used C# and VB.net using Script task and Script Components in SSIS.
• Generated flat files, Excel files and CSV files dynamically using SSIS.
• Performed ETL Mapping using MS SQL Server Integration Services.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Developed Test Cases bases on Business Requirement Specifications and Function Design Documents.
• Experienced in designing and execution of Test Plans, Test Scenarios and Test Cases based on the requirements for the applications. Interacted with testing team to fix the defects raised during the testing period.

Environment: MS SQL Server 2008, MS SQL Server Integration services (SSIS), MS SQL Server Reporting Services (SSRS), BIDS, Visual Studio 2008, VSS 2008, C#, VB.net, Microsoft .NET framework 3.5.

Confidential, Addison, TX

MS SQL Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Developed 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, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Migrated data from DB2 database to SQL Server database using SSIS.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008R2 Reporting Services (SSRS). Monitored and tuned report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Responsible for table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance. Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Set up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Reviewed Test cases developed by QA team members as part of peer review.
• Created, Reviewed and Executed test cases and test scripts for System, Integration testing.

Environment: MS SQL Server 2008R2, T-SQL, SQL SSIS, SSRS, SSAS, Windows server 2003, Visual Source Safe, SQL Profiler, Erwin 7.2, Oracle 10g, DB2, VB.Net, Query Analyzer, BCP, HP Quality Center