ANOOP KUMAR MISRA Email:

acen4r@r.postjobfree.com

MS BI Developer Phone: +1-

630-***-****

Summary:

* Over 8 years of experience as SQL Developer, SSIS Developer, SSRS

Developer with good experience in SQL Server 2008R2/2005/2000 of

healthcare, telecom, insurance and banking domain.

* Extensive experience in business requirement gathering, data analysis,

scoping, documentation (business requirement, functional specification, use

case, business process flows, gap analysis, Test plan, test cases, user /

training documentation etc.), reporting, designing UI Mockups,

conducting UAT and end user training.

* Conversant with all phase of Software Development Life Cycle (SDLC)

involving Systems Analysis, Design, Development and Implementation. Worked

in Agile -scrum methodology.

* Extensive experience in MS SQL Server 2008 R2/2005/2000, Business

Intelligence in SQL Server Integration Services, SQL Server Reporting

Services, and SQL Server Analysis Services.

* Strong experience in SQL Development, ETL development using Microsoft SQL

Server Integration Services (SSIS), Business Intelligence delivery using

Microsoft SQL Server Analysis Services (SSAS)and Reporting solutions using

Microsoft SQL Server Reporting Services (SSRS).

* Strong experience working with BCP, DTS, SSIS packages, creating jobs and

linked servers for MS SQL Server/Sybase databases.

* 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 creating, configuring and fine-tuning ETL workflows designed in

DTS and MS SQL Server Integration Services (SSIS).

* Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS

Packages.

* Expert in Developing SSIS Packages to Extract, Transform and Load

(ETL)/DTS data into the data warehouse from Heterogeneous databases such as

Oracle, DB2, Sybase and MS Access.

* Expert in Creating and Deploying SSRS Reports on the portal for user

accessibility.

* Experienced 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 2008/2005.

* Hands-on in development of Drill down Reports in SSRS and

Generated daily, weekly and monthly reports for the manager.

Technical Skills:

RDMS : MS SQL Server 2008 R2/2005/2000, ORACLE 10g/9i, PL/SQL

MS Access 2000/XP/2007

Database Tools/Utilities : SSRS, SSIS, Enterprise Manager, Query

Analyzer, SQL Profiler

Data Transformation Services, Replication, Jobs and Task

Creating and Scheduling, Analysis Services, Crystal

Reports 9

Programming Languages : T-SQL, PL/SQL, Visual Basic 6.0, VB.NET,

ASP.NET

Operating Systems : Windows 2000/2003 Server, Windows NT

Designing Tool : Visio and Rational Rose

Source Control Tool : Microsoft Visual Source Safe, TFS, SVN.

Others : FrontPage, Dreamweaver, MS Office

Education:

Bachelor in Science

Professional Experience:

T-Mobile, Bellevue WA Nov' 2013 - May' 2014

SQL Server Developer /Data analyst/ SSIS, SSRS, SSAS developer

As America's Un-carrier, T-Mobile US, Inc. (NYSE: "TMUS") is redefining the

way consumers and businesses buy wireless services through leading product

and service innovation. The company's advanced nationwide 4G and 4G LTE

network delivers outstanding wireless experiences for customers who are

unwilling to compromise on quality and value. Based in Bellevue, Wash., T-

Mobile US operates its flagship brands, T-Mobile and Metro PCS. It

currently serves approximately 43 million wireless subscribers and provides

products and services through 70,000 points of distribution.

Responsibilities:

. Developed and modified complex stored procedure based processes

supporting ETL processes in a Data Warehousing environment as well as

creating reports in Reporting Services and other data related tasks

. Worked with customers and/or analysts to define and/or review business

requirements for new ETL processes and reports. Design and develop ETL

processes and reports that meet team standards and use consistent

methodology and development approach. Performed comprehensive unit

testing of all work

. As part of the rotating DBA responsibility - ownership of all

processes running on the Database servers and respond to issues, as

well as performed proactive performance tuning, data archiving, and

identified any areas where we can optimize of processes and

environment

. Created and maintain technical designs, data dictionaries, and systems

operations documentation.

. Worked for production support as well as development support of Supply

Chain Operation. Completed different type of break fix and loaded

business data for reporting services

. Performed on data validation before loading different type of data

files on daily basis as per defined by business user and worked with

monthly new project deployment

. Used SSIS to transform and load data into SQL database via FTP from

XML files, MS Excel as source data

. SQL Enhancement/New Report by adding new data source system for

production and scheduled job for the process

. Worked for Functional and Technical design to speed up the process and

query optimization.

. Completed change request work to load data with extra columns to

understand details data and started new import source to process the

data. Worked for Data Truncation and reload as per the requirement to

change in import for data quality

. Executes dashboard and automation for repetitive processing tasks, as

well as offers continued support to upgrade and modify automation.

Environment: MS SQL Server 2008r2, SAP, BMC Remedy, Data Modeling Tools,

Visual Basic/VBScript, ASP.NET, C#, Excel (including VBA), Oracle, Hyperion

Essbase, Agile software development (TDD, XP, Notepad++

BD (Becton Dickinson) Franklin lakes, NJ May'12 - Oct' 13

SQL, SSIS, SSAS, SSRS DEVELOPER/Data analyst

BD (Becton Dickinson) is a medical technology company that serves

healthcare institutions, life science, researchers, clinical

laboratories, industry and the general public. BD manufactures and

sells a broad range of medical supplies, devices, laboratory

equipment and diagnostic products

Responsibilities:

* Created new Stored Procedures, Functions and Triggers using T-SQL to

migrate the data from various tables as well as various databases

* Created complex views by joining more than 20 tables from different SQL

instances using Linked Server

* Designed and developed SSIS (ETL) packages to validate, extract,

transform and load data from OLTP system to the Data warehouse and Report-

Data mart.

* Created SSIS package to load data from Flat File to Data warehouse and

Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition

Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

* Used various SSIS tasks such as Conditional Split, Derived Column etc.

which did Data Scrubbing, including data validation checks during Staging,

before loading the data into the Data warehouse.

* Applied various data transformations like Slowly Changing Dimension,

Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS.

Developed and deployed data transfers packages using SSIS, also maintained

the jobs running on Servers.

* Responsible for creating database objects like table, Views, Store

Procedure, Triggers, Functions etc. using T-SQL to provide structure to

store data and to maintain database efficiently.

* Created SSIS Packages to perform filtering operations and to import the

data on daily basis from the OLTP system, DSR to SQL server. Responsible

for implementation of data viewers, SSIS Logging, error configurations for

error handling the packages.

* Responsible for managing BI environment, which includes Business model,

Data Model, Data sources, ETL tools, target data warehouse, Data marts,

OLAP analysis and Reporting tools. Designed, deployed, and maintained of

various SSRS Reports in SQL Server 2008 R2.

* Wrote Parameterized Queries for generating Tabular reports and Sub

reports using Expressions, and Functions, Sorting the data, Defining Data

sources and Subtotals for the reports using SSRS 2008 R2.

* Defined report layouts including report parameters and wrote queries for

drill down reports using SSRS 2008 R2. Developed complex reports using

multiple data providers, user defined objects, aggregate aware objects,

charts, and synchronized queries.

* Administered interface to organize reports and data sources, schedule

report execution and delivery, and track reporting history using SSRS 2008

R2. Responsible for the Performance tuning of the SQL Commands with the

use of the SQL Profiler and Database Engine Tuning Wizard.

* Applied various Created Tabular reports, Cross Tabs, Drill down, Charts,

Functions and Maps using SSRS. Customized reports by adding Filters,

Calculations, Prompts, Summaries and Functions. Created reports to

retrieve data using Stored Procedures that accept parameters.

* Developed Report Models using report builder and distributed reports in

multiple formats using SQL Server Reporting Services (SSRS) in Business

intelligence development studio (BIDS). Created Alerts for successful or

unsuccessful completion of Scheduled Jobs.

Environment: SQL Server 2008 R2/2005/2000, T-SQL, Agile-Scrum, SSRS, SSIS,

Teradata, DB2 UDB 9.x, Visio, EXCEL, HTML, JavaScript

ERT (e-Research Technology), NJ Mar '10 - Apr '12

SQL Server Developer /Data analyst/ SSIS, SSRS, SSAS developer

ERT is a global organization with headquarters in Philadelphia, PA. ERT

is committed to helping collect high-quality patient safety and efficacy

endpoint data for use in clinical drug development and healthcare settings.

Provide the most accurate, cost-effective, and convenient support systems

to collect timely, regulatory-compliant data. ERT team of experts will

work together to increase the integrity and reliability of patient data to

collect, analyze, and deliver. ERT delivers the most widely deployed

solutions in centralized cardiac safety, respiratory service, suicidal risk

assessment, and Clinical Outcome Assessments (COA) which includes patient,

clinician, and observer reported outcomes. Provide unparalleled scientific

and regulatory leadership to biopharmaceutical, Contract Research

Organizations (CROs), medical device companies, hospitals, and other

healthcare organizations around the globe.

Responsibilities:

* Gathering requirements, Analysis, Design, functional & technical

specification, Coding, testing and Document preparation.

* Support Data team and QA team for data extraction and reporting jobs.

* Responsibilities include Database Design and Creation of User Database.

* Logical, Physical Database design

* Created complex SQL queries for data extraction and reporting

* Designed and wrote stored procedures, functions using T-SQL

* Supported application written in Oracle PL/SQL and converted into T-SQL

packages.

* Created data extraction ETL jobs using SSIS, DTS, extracting data from MS

ACCESS, Oracle and MS Excel and loading into SQL Server Databases.

* Creation of backend SQL Server TABLES, INDEXES, VIEWS.

* Scheduling Jobs and Alerting using SQL Server Agent.

* Created T-SQL Stored procedures, Functions and Triggers

* Running DBCC checks and fixing data corruption in Application databases

* Created reports using SSRS (SQL Server reporting services).

* Created matrix, reports, drill down reports and developed reports with

graphs using SSRS.

* Performed Tuning, cube Partitioning, dimension design including

hierarchical and Slowly Changing Dimensions.

* Worked on enterprise Reporting Lifecycle. Created Ad-hoc reports, Monthly, weekly reports.

* Transformed data from various data sources using OLEDB

* Developed Various Operational, drill-through and drill-down reports using

SSRS.

* Performing query plans and making sure each and every query is using

appropriate indexes.

* Data transfers between various servers using BCP and DTS.

* Implementing DTS Packages for transferring data.

* Wrote SSIS scripts for data transfer.

* Created Test cases, Test Plan, and Test conditions for QA testing.

* Supported the QA team for Data validation, Data extraction and SQL Query

optimization.

* Developed custom reports using SSRS/SQL Server BI studio.

* Decided upon the locking strategy that could be used for various batch

Programming structures & Transactions.

* Used Performance Monitor and SQL Profiler to optimize queries and enhance

the performance of database servers.

* Used MDX queries for pre calculated measures.

* Created report Model on SSAS Cubes as well as changing default

configuration on existing Cubes

Environment: SQL Server 2000/2005, T-SQL, SSAS,SSRS, Oracle 10g, Teradata,

PL/SQL,MS ACCESS, C#.NET, VB.NET, VBA, XML, BCP, DTS, Windows

2003/2000(Advanced Server), EXCEL, Crystal reports, Windows 2003 advanced

Server.

JP Morgan Chase, New York Jan '09 - Feb '10

Online Banking Application

SQL Server Developer/ SSIS, SSAS, SSRS developer

JP Morgan provides online banking with the information you need and

convenient Internet access to your JP Morgan Bank accounts - 24 Hours a

day, 7 days a week. With the help of online banking, the customer can

perform various banking activities.

With a global platform that includes capital markets, prime services,

alternative investments, foreign exchange, structured products and risk

management, J.P. Morgan is well positioned to serve the evolving needs of

financial sector clients.

Responsibilities:-

* Involved in all the phases of SDLC.

* Have performed the team supervision in the absence of project manager

more than two times and had completed the task successfully.

* Filtered bad data from legacy system using complex T-SQL statements, and

implemented various types of Constraints and Triggers for Data Consistency

using SQL Server 2005

* Documented the Stored Procedures and User Defined Functions (UDF) for

future references and maintenance.

* Used DDL and DML Triggers, Stored procedures to check the Data Integrity

and verification at early stages before calling them.

* Used SQL Server Integration Services (SSIS) and its tools to Extract,

Transform and Load data into Data Warehouse. Developed, deployed and

monitored SSIS Packages

* Creating SSIS Package configurations for executing in different

environments.

* Enabled Check points in SSIS package.

* Created break points in order to view the status of data, variables and

over all status of SSIS package.

* Extensively involved in designing the SSIS packages to export data of

flat file source to SQL Server database.

* Enhancing and deploying the SSIS Packages from development server to

production server.

* Developed and Deployed different types of Reports like List, Matrix, and

Chart and Sub Reports etc.

* Designed and developed parameterized reports, linked reports, matrix and

tabular reports with drill down, drill through and drop down menu option

using SSRS.

* Extensive use of Import/Export wizard to convert T- SQL Queries, Data and

Reports from different forms like XML file, MS Excel file, TTF file, PDF

file and other formats to SQL data type and Vice versa.

* Created/ Maintained clustered/ non clustered Indexes for fast and

efficient reporting process.

* Used SSRS to create interactive reports with an ability to drill down

into details.

* Create OLAP cubes with SSAS based on multidimensional database with star

schema or snow flake schema

* Extensive experience using Data Mining tools in Microsoft Analysis

Services (SSAS).

* Extensively involved in the SSAS storage and partitions and Aggregations,

Calculation of queries with MDX, Data Mining Models, developing reports

using MDX and T-SQL.

* Built MDX queries and Data Mining Expression (DMX) queries for Analysis

Services & Reporting Services.

* Created several MDX queries according to business requirements.

* Created MDX script for representing Cube Calculation using SSAS.

* Responsible for General Database Administration and Performance tuning.

Environment: Windows XP Professional (SP2), SQL 2005, SQL Profiler, SSIS

2005, SSAS 2005, SSRS 2005, TOAD.

Verizon, NJ Feb '07 - Dec'08

SQL Programmer SSIS/SSRS

Verizon Wireless is a recognized leader in customer service, investing

heavily in services and self-service tools that consistently deliver

customer satisfaction. Operate more than 1,900 retail locations. Verizon

Wireless has invested more than $80 billion since it was formed in 2000-on

average more than $6 billion every year-to increase the coverage and

capacity of its premier nationwide network and to offer customers

innovative services that enhance their productivity and quality of life.

Description: Worked on development cellular Usage tracking and

reconciliation system

Responsibilities:

* Worked on different requirement gathering with the business side.

* Documenting the design, doing code development and implementation.

* Involved in database Schema design and development.

* Worked as a developer in creating complex stored Procedures, SSIS

packages, triggers, Cursors, tables, and views and other SQL joins and

statements for applications.

* Used SSIS packages to load the data from spreadsheet into the database

and also used packages to move data between databases (flat files) on

different servers.

* Extracted data from various data sources CRM, ERP, Legacy

* Used SSIS to transform data into SQL database via FTP from Text files, MS

Excel as source.

* Used SMA Job scheduler to schedule jobs as advised by the business user.

* Worked as a developer in creating complex Stored Procedures, SSIS

packages, triggers, cursors, tables, and views and other SQL joins and

statements for the applications.

* Created format files to support BCP transformation in SSIS via FTP.

* Worked on SSRS to handle Ad-hoc requests.

* Designed tables, constraints, necessary stored procedures, functions,

triggers and packages using T-SQL.

* Worked on DTS packages on SQL server side.

* Created efficient Queries, Indexes, Views and Functions.

* Enforced Security requirements using triggers to prevent unauthorized

access to the database.

* Worked on putting together the test cases for testing after

implementation

* Worked on defects assigned to me on test director for the maintenance of

the existing system.

* The design was implemented in production successfully.

Environment: MS SQL server 2000, Oracle, C#.NET, ASP.NET, TOAD, DTS, T-SQL,

Win NT/2000/XP

JetBlue, NY Feb '06 - Jan '07

SQL Programmer

JetBlue Airways Corporation often stylized as "jet Blue", is an American

low cost airline. The company is headquartered in the Long Island City

neighborhood of the New York City. Is main base is JFK International

Airport, also in Queens. The airline mainly serves destinations in the

United States, along with flights to the. JetBlue serves 84 destinations in

24 states, and 12 countries in the Caribbean, South America and Latin

America

Description: As part of development team, I involved in developing DTS

packages, Stored Procedures, XSD & XML

Responsibilities:

* Involved in data transfer from source to target specifications.

* Created complex stored procedures, functions, views, triggers and

indexes.

* Involved in assisting QA team in deploying and testing the applications

which uses SQL server as database

* Experienced in performance tuning and optimizing for SQL server

application by using performance monitor

* Extensive experience in creating Sub-reports, drill-down reports, summary

reports and parameterized reports in SSRS.

* Generated reports using SSRS that could be used to send information to

different primary vendors, clients and managers

* Created DTS package to schedule the jobs for batch processing.

* Performance tuning to optimize SQL queries using query analyzer.

* Created indexes, constraints and rules on database objects

Environment: MS SQL Server 2000, T-SQL, Query Analyzer.

Contact this candidate