SUMMARY:

• Over 9+ years’ experience in Information System Technology and Business, System Analysis, database design/development, Programming, development of MS SQL SERVER 2000,2005,2008, 2008R2, 2012 databases in on Production (24/7), Testing, Development/Staging.
• Experience in Auto, personal Insurance, Finance, Manufacturing, Health Insurance and Real Estate domains with expertise in MS SQL Server 2000/2005/2008 R2, 2012 and Microsoft’s suite of products like SSIS, SSRS, SSAS, and Share Point 2012, Power BI Dashboard, DAX, Tabular model.
• Proficient in Microsoft BI Tools and Tableau generate reports and dashboards.
• Worked on Data mart, created Tabular model, wrote complex measures, deployed model on different testing analysis servers, created Power BI Reports.
• Basic knowledge of Azure technologies
• Experienced with Tabular Models to speed up analysis life cycle based on different data volumes.
• Expert in developing and designing reports through SSRS and Excel
• Expert in Ad - hoc reports, drill down and drill through reports and cross tab reports.
• Experienced in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012/2008/2005
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions and Triggers to facilitate efficient data manipulation and data consistency
• Experience in creating various types of reports (table, chart and matrix report, web reporting by customizing URL Access etc.) using SQL server Reporting Services(SSRS)
• Designed solution designed documents and implemented the code according to that.
• Extensive knowledge in Tuning SQL queries improving the performance of the Database.
• Experience in creating SSIS jobs in SQL Server Agent, Alerts and schedule SSIS/DTS Packages.
• Experience in Business requirement gathering, Analysis and Documentation of the requirements.
• Experience on working full load, Incremental load, Change data capture, Slowly changing Dimension and data ware house concepts.
• Skilled in building effective productive working relationships with co-workers.
• Work well both individually and with others in team environments.
• Honest, energetic, hardworking, and aggressive with excellent analytical and Organizational Skills.

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R2, 2008/2005/2000, MS Access, Transact-SQL (T-SQL),
• SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Visual Studio 2005/2008/2010, SQL Developer, Windows Server- 2003/NT/XP/2000, Windows vista, Windows 7, Windows8
• Power BI, DAX, Tabular, DAX, KPIs.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. MS SQL Server/ Power BI Developer

Responsibilities:

• Did Installation and configuration of SQL Server 2005/2008/2012, Visual Studio Data server Tools, Team Explorer... etc
• Used BI xPress for Auditing, monitoring, and notification to SSIS packages and validated and deploy the SSIS packages.
• Worked on SQL advanced features such as Merge, xml path, dynamic sql queries, try-catch, Change data capture... etc
• Knowledge on SQL Partitions and SSIS Partitions SSIS packages.
• Involved in Level 3 to solve the production issues which were created by users.
• Designed solution designed documents and implemented the code according to that.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Designed solution designed document and implemented the code according to that.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Deployed the generated reports directly on the client’s workstation.
• Created complex Stored Procedures for better performance to generate reports
• Designed and developed various Medical Bill review & operational reports using SSRS.
• I have given the Production support to Medical Review, GC Claims Reports ... etc.
• Deployed the reports on Share point 2012 and Report manager ... etc
• Gathered and documented business requirement for KPIs, dashboards and Reports.
• Developed and designed the different visualizations Charts, Line Charts, Pie Charts, Maps, Tiles, Cards, Images, Power View, tables, multiples visualization, Bubble and scatter chart, key performance indicator using Power BI tool.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Worked with team on Azure technologies and have understanding of the VB.net coding in Azure.
• Designing and developing SQL Server Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.

Environment: MS SQL SERVER 2000/2005/2008 /2008 R2,2012, Share point 2012, DTS Designer, Enterprise Manager, T-SQL, SQL Server Agent, Import/Export Wizard, SQL Server Agent, SQL Server Profiler, VB.NET, MS Excel 2010, Visual Studio 2010, BIDS 2008, TFS, Prolin .. etc

Confidential, Berkeley Heights, NJ

Sr. MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Designed and developed the data load processing from scratch.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Gave the flexibility to users to run the summary and detail reports by fiscal year, divisions.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Did scheduling, creating snapshots and subscriptions for the reports using SSRS
• Worked on re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Run Import/Export wizard to provide Excel files to Managers for particular reports
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Extract the data from excel source file from share point portal and transform the data and load into the tables through SSIS package
• Automated the process to load the data on new versions dynamically
• Involved in a complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Used various Transformations in SSIS Dataflow, Control Flow uses For-loop-Containers and Fuzzy Lookups etc.
• Involved in design, programming, deployment and Unit Testing of requests Reports

Environment: MS SQL SERVER 2000/2005/2008 /2008 R2,2012, DTS Designer, Enterprise Manager, T-SQL, SQL Server Agent, Import/Export Wizard, SQL Server Agent, SQL Server Profiler, VB.NET, MS Excel 2010, Visual Studio 2010, BIDS 2008 and TFS.

Confidential, Secaucus, NJ

Sr. MS SQL Server BI Developer

Responsibilities:

• Installed and configured the SQL Server 2008/2008R2, Visual Studio 2010, Team Explorer... etc.
• Processed the data from various sources through the WOTF ETL, from the point of pulling the Metadata / Data from all sources to the point of final output made available in database tables / views / Stored Procedures for reporting needs
• Created Datasets in dynamic SQL, stored procedures for SSRS
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Created Report Snapshots to improve the performance of SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
• Moved database objects from one environment to different environments using import/export wizard and through SSIS package
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Created tables, views, constraints, complex stored procedures, functions... etc.
• Created Complex SSIS Packages using SSIS to extract data from source files to database tables
• Created SSIS packages for fast load and incremental load
• Created SSIS Packages from excel spreadsheet and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations
• Wrote the PL/SQL script and queries and stored procedures.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created the folder structure, read .xml, .xlsx, .xls, .txt files through SSIS
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Environment: MS SQL SERVER 2000/2005/2008 /2008 R2, DTS Designer, Enterprise Manager, T-SQL, SQL Server Agent, Import/Export Wizard, SQL Server Agent, SQL Server Profiler, VB.NET, MS Excel 2010, Visual Studio 2010, BIDS 2008

Confidential, NJ

Sr. MS SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Did Installation and configuration of SQL Server 2005/2008, Visual Studio, Team Explorer... etc.
• Used BI xPress for Auditing, monitoring, and notification to SSIS packages and validated and deploy the SSIS packages.
• Wrote Oracle PL/SQL code to pull the data from Oracle database and sending to the destination tables.
• Worked on SQL advanced features such as Merge, xml path, dynamic sql queries, try-catch, Change data capture... etc.
• Worked on SQL Partitions and Partitioned SSIS packages.
• Involved in Level 3 to solve the production issues which were created by users.
• Designed solution designed documents and implemented the code according to that.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Designed solution designed document and implemented the code according to that.
• Created tabular, matrix, chart, drilldown reports, parametric, cascaded reports and dashboards and scorecards reports according to business requirement.
• Deployed the generated reports directly on the client’s workstation.
• Created complex Stored Procedures for better performance to generate reports
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005/2008
• Migrated DTS packages to SSIS 2008 Version.
• Communicated and collaborated effectively with clients and project teams to Business Requirements.
• Developed/Implemented MS/SQL solutions and worked on data warehouse (OLAP) and involved in to working with integration, relational, multidimensional and presentation components
• Worked on MS SQL Server 2000/2005/2008 BI/DW tools: SSIS, SSAS and SSRS
• Created SSIS Packages using different type task and with Error Handling using control and dataflow elements.
• Generated dynamic stored procedures, triggers, Cursors, Joins for the database development
• Created dimension table and applying Slowly Changing Dimension Types and involved in to Creating, Scheduling the Jobs in SQL SERVER AGENT.
• Involved in OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube
• Worked on OLAP Data warehouse, Modeling, Designing and Implementation.
• Designed OLAP cubes, Dashboard Reports, and scorecards according to the business requirement.
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL SERVER 2000/2005/2008 V, DTS Designer, Enterprise Manager, T-SQL, SQL Server Agent, T-SQL, SQL Server Agent, SQL Server Profiler, VB.NET, MS Excel 2010, Visual StudioBI xPress

Confidential, Purchase, NY

Sr. MS SQL Server Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005/2008
• Migrated DTS packages to SSIS 2008 Version.
• Communicated and collaborated effectively with clients and project teams to Business Requirements.
• Developed/Implemented MS/SQL solutions and worked on data warehouse (OLAP) and involved in to working with integration, relational, multidimensional and presentation components
• Worked on MS SQL Server 2000/2005/2008 BI/DW tools: SSIS, SSAS and SSRS
• Created SSIS Packages using different type task and with Error Handling using control and dataflow elements.
• Generated dynamic stored procedures, triggers, Cursors, Joins for the database development
• Created dimension table and applying Slowly Changing Dimension Types and involved in to Creating, Scheduling the Jobs in SQL SERVER AGENT.
• Wrote the dynamic SQL and retrieve data from different linked servers.
• Created the SSIS parent and child packages using package task with variables.
• Involved in OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube
• Worked on OLAP Data warehouse, Modeling, Designing and Implementation.
• Designed OLAP cubes, Dashboard Reports, and scorecards according to the business requirement.
• Experience in Designing and Building the Dimensions and cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL SERVER 2000/2005/2008 V, DTS Designer, SSIS/SSRS/SSAS 2005/2008, Enterprise Manager, T-SQL, SQL Server Agent, SQL Server Profiler, VB.NET, MS Excel 2010, Visual Studio.

Confidential, Harrisburg, PA

MS SQL Server BI Developer

Responsibilities:

• Responsible for gather the requirements and generate the report based on user requests.
• Responsible for writing complex SQL queries, stored procedures, views, triggers, T-SQL
• Did data analysis & reports development for Confidential project.
• Developing SSRS reports, TFS check-in, check-out and configured the reports for deployment.
• SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
• Involved in design Confidential application using VB.NET, ASP.NET, Frame work.
• Designed ad-hoc reports using Report Model and configured using Report Manager.
• Used complex expressions to group data, filter and parameterize reports.
• Created and designed the Xcelsius Dashboards and pie charts, bar charts,
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Experienced in designing reports through Report Builder and Report Designer.
• Identified and worked with parameters for parameterized reports in SSRS 2005/2008.
• Creation of temporary tables, efficient index mechanisms and optimizing joins to match the performance expectations of the system

Environment: MS SQL SERVER 2000/2005/2008, SSIS 2005/2008,, MS Excel, TFS, ASP.net, VB.net

Confidential, Jersey City, NJ

SQL SERVER Developer

Responsibilities:

• Responsible for Documenting the Business Requirement and taking confirmation from Business users.
• Participated in review of Existing universes and their modifications to meet the user reporting requirements. Implemented enhancements to the existing universes, fixed joins and contexts problems, applied aggregate awareness to speed up the query time, created cascading prompts and new objects with customized LOV’s to support the current environment.
• Responsible for analyzing, designing, implementing and maintaining complex components of Reporting / Business Intelligence information systems (business objects XI) that support critical business operations
• Worked with ETL Development Team for extracting data from Data ware house, perform Transformations as per the requirement and Load the data into existing Oracle DB, and data integration for better performance.
• Created Reports based on Views, Stored Procedures and Commands. Modified existing Report based on the User requirement and created running totals, sub-totals and used for the Reports
• Involved in re-designing or customizing the existing Materialized Views and Stored Procedures to suit the Reporting needs and pull the records from multiple tables using JOIN’s.
• Developed Parameterized Reports, Cross tab Reports and Sub Reports involving complex formulas.
• Involved in performance tuning of reports by eliminating filters at report level.
• Responsible for showing all of your business intelligence (BI) content in one consolidated view using Dashboard builder.
• Used prompts to make Reports confined to a particular case as per business requirement.
• Generated sub Reports, linked and unlinked Reports, Reports on demand
• Worked on complex data models and ERD diagrams to structure the data.

Environment: SQL Server 2000/2005 Enterprise Edition, T-SQL, SSIS 2005, VisualStudio.NET, Windows 2000 Advance Server, Windows 2003 Advance Server, MS Excel, MS Access