PROFESSIONAL SUMMARY:

• 9+ years of administration and development experience on Database Design and Development in SQL Server 2012 R2/2008 system in OLTP and OLAP environment.
• Excellent experience in SSIS, SSAS and SSRS of MS SQL Server.
• Highly expert in translating Business System Design document into technical design document.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In - depth knowledge of Confidential -SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using Confidential -SQL.
• Experience in writing complex Confidential -SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Excellent knowledge of using variables and expressions in packages.
• Experience in scheduling SSIS packages using SQL Server Agent.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2012 / 2008.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Expert in resolving the performance issue of SSIS packages.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, and XML).
• Design, Develop, and Enforce new EDI procedures (65C Plus, 835 and 837 Transactions, ICD 10) and the changes to fresh and active EDI clients.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

TECHNICAL SKILLS:

MS-SQL Server 2012 R2/2008, SQL Server BI Development Studio (BIDS), MS Visual Studio 2012/2008, SQL Server Integration Services (SSIS), Power Builder, SQL server Analysis Services (SSAS), SQL server Reporting Services (SSRS), MS Access, Confidential - SQL, C, C++, C#, HTML, XML, Java, ASP .NET, VB6 .NET, Crystal Reports, Erwin 7.2/4.5/4.0, MS Visio 2007/2003, Clear Quest, Autosys, DTS, Windows 7/Vista/NT/XP/ 2003/2000/98 ,Windows 2000Advanced Server, QNXT 4.7/5.0, TIDAL Job Scheduler.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Team Lead / Sr. SQL-BI Developer

Hardware/Software: SQL Server 2012 R2 /2008, SQL Server BI Development Studio (BIDS) 2012/2008, SQL Server Integration Services (SSIS), MS Visio 2007/2003, Windows 7/Vista/NT/XP / 2003/2000/98 , Ticket Tracker, Team Foundation Server (TFS) 2012.

Responsibilities:

• Worked as a Team Lead and a developer in creating complex Stored Procedures, Triggers and Functions.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Responsible for creating the reports based on the requirements using SSRS 2012.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administering SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.

Confidential, Westlake Village, CA

SQL/ BI Developer

Hardware/Software: SQL Server 2012/2008, SQL Server BI Development Studio (BIDS) 2008/2005, SQL Server Integration Services (SSIS), MS Visio 2007/2003, Windows 7/Vista/NT/XP / 2003/2000/98 , Windows 2000Advanced Server.

Responsibilities:

• Designed and Developed new programs like Confidential and Confidential by which the mailers are sent as a reminder to the members.
• Designed and developed a new “Incentives” program which gives points (incentives) to the members who got done the vaccines/shots for which the members were reminded about certain Preventive and Chronic conditions.
• Designed, Developed and maintained a system level process in which new files are loaded automatically in the standard tables and creates the history of the all the members about what was given from the carriers.
• Contacting different carriers over the phone/email if the claims file received has bad data.
• Creating Automatic emails for status reports or failures for various ongoing processes to avoid silent failures.
• Organizing and leaving meetings with clients (carriers) and explain them about the Confidential & Confidential programs on custom-made power point slides.
• Working as a database developer in creating and maintaining complex Stored Procedures, Triggers and Functions.
• Create functions to provide custom functionality as per the requirements.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Maintain and manage all versions of data models for production, testing and developing databases.

Confidential, Bothell, WA

SQL/ BI Developer

Hardware/Software: SQL Server 2012/2008/2005 , SQL Server BI Development Studio (BIDS) 2008/2005, SQL Server Integration Services (SSIS), MS Visio 2007/2003, Windows 7/Vista/NT/XP / 2003/2000/98 , Windows 2000Advanced Server.

Responsibilities:

• Working as a database developer in creating and maintaining complex Stored Procedures, Triggers and Functions.
• Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
• Create functions to provide custom functionality as per the requirements.
• Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
• Maintain and manage all versions of data models for production, testing and developing databases.
• Resolve and troubleshoot complex issues.
• Perform and execute data extraction, transformation and loading using ETL tools.
• Created, maintained and Deployed SSIS packages and SSRS Reports.

Confidential, Honolulu, HI

SQL/SSIS Developer

Hardware/Software: SQL Server 2012/2008/2005 , SQL Server BI Development Studio (BIDS) 2008/2005, SQL Server Integration Services (SSIS), MS Visio 2007/2003, Windows 7/Vista/NT/XP / 2003/2000/98 , Windows 2000Advanced Server, QNXT 4.7/5.0, TIDAL job scheduler, 65C Plus, 835 and 837 Transactions,ICD10 data.

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module.
• Monitor all EDI file processing and perform troubleshoot on processes to resolve all transaction file issues.
• Design, Develop, and Enforce new EDI procedures (65C Plus, 835 and 837 Transactions, ICD10 data) and the changes to fresh and active EDI clients.
• Created SSIS packages to migrate data from different data sources to data warehouse.
• Successfully extracted transformed and load data into data warehouse.
• Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
• 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.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.

Confidential, Cleveland, OH

SQL/SSIS/SSAS/SSRS

Hardware/Software: SQL server 2008/2005, Windows XP/2003, BIDS 2005, Windows 2000 Advanced Server, Microsoft Share point Portal Server, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL Lite Speed, Dell Power Edge 2650, 1750, 2600.

Responsibilities:

• Installation SQL Server 2005 with the latest service packs.
• Migrated Database from SQL Server 2000 to 2005 by using side by side migration.
• Creating tables, indexes and designing constraints.
• 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.
• Used ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2005.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Developed and designed cubes with calculated members, Design Dimensions and using the MDX expressions for the various calculated members, actions and KPI.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Created and Maintained Database Maintenance Plans.

Confidential, Newark, DE

SQL/SSIS/SSAS/SSRS Developer

Hardware/Software: SQL Server 2005, BIDS 2005, Integration Services 2008/2005, Oracle 9i, Visual SourceSafe, TSQL, Autosys, Rational Clear Case, Clear quest, MS Access, Windows XP/2003 Server.

Responsibilities:

• Responsible for creating logical and physical model using ERWIN.
• Built a package to transfer data between OLTP and DW databases.
• Created Views to reduce database complexities for the end users.
• Performed Confidential -SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Developed SSIS Packages using Derived Columns, Condition Split, 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.
• Created a table to save dirty records.
• Set up Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and Confidential -SQL.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• 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 Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

Confidential, New York, NY

SQL Server Reporter and Developer

Hardware/Software: MS SQL Server 2005/2000/7.0 , DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, Erwin, MS Visual Source Safe, FTP Communication, MS-Visual Studio, Power Builder, MS Access, Oracle 10g, UNIX, XML,XSLT, ADO.Net.

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Formatted the reports using the Global variables and expressions.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administering SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Configured replication servers and transactional replication between production and standby server for disaster recovery. Examine two-way database replication using SQL server.

Confidential

SQL Server BI Developer

Hardware/Software: MS SQL Server 2000, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB, Crystal Report.

Responsibilities:

• Gathered functional requirements and written the technical specifications
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote Confidential -SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Developed stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• 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.