Summary

• Over 8 years of experience in the IT industry, includes Software Analysis, Design, Development, Customization and Implementation of various business applications
• Extensive experience in SQL Server, T-SQL, Oracle and MS Access
• Experience in the complete life cycle of databases which includes the design a database, populating lookup data, creating Stored Procedures as per front end developer's requirement and commercial transitions, writing Triggers, creating user defined functions and created views to simplify the complexity of the data structure
• Experience on T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function
• Experience in using recursive CTEs, CTE, Temp tables and effective DDL/DML triggers to facilitate efficient data
• Experience in Extraction Transformations and Loading ETL tools like SQL Server Integration Services SSIS , Data Transformation Services DTS , Bulk Insert, and Bulk Copy BCP
• Skilled in error and event handling: precedence constraints, Break Points, Check point and Logging
• Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS package Designer
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc using SSIS/DTS utility
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C in script component of SSIS
• Experience in creating configuration files to deploy the SSIS package across all environment
• Based on the business requirements, worked on FACT's and DIMENSIONS
• Expertise in writing MDX query in OLAP Databases
• Experience in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes
• Experience in designing, creating, processing of cubes using SSAS
• Excellent experience in creating, managing and deploying various types of reports using SQL Server Reporting Services and Report Manager
• Extensive experience in developing reports using SQL Server Reporting Services SSRS , Crystal Reports, Oracle Reports and MS Access reports
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server reports in SSRS 2005/2008/2008 R2 using data from ETL Loads, SSAS cubes and various heterogeneous data sources
• Experience in Capacity planning and Disaster Recovery Planning
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor
• Monitored and tuned application using the performance Diagnostic tools such as SQL Profiler
• Experience in maintaining security on multiple servers and multiple databases with Windows authentication and SQL Authentication
• Experienced in Migrating databases from SQL Server 2005 to SQL Server 2008
• Good knowledge of parallel processing used it for faster query processing and loading data
• Good experience with database designing, creating logical and physical data models using Erwin
• Knowledge on AS 400 platform
• Experience working with Visual Studio 2010 and 2012

• Databases : Oracle 10g/9i/8i/8.0, Access, MS-SQL Server.
• Tools/Utility : Enterprise Manager, SQL Server Management Studio SSMS , SSIS, Database
• Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, Query Builder,
• Informatica, Erwin
• Languages : C, C , SQL, PL/SQL, UNIX Shell Programming, HTML, Visual Basic, Java, XML.
• Web Applications : Active Server Pages 2.0.
• Testing Tools : Win Runner 7.0, Test Director 8.0
• GUI Tools : Forms 5.0/6i/9i, Reports 3.0/6i/9i
• Other : MS Word, Excel, PowerPoint, Visio

BMO Harris Bank, IL

Sr. BI/SQL Web Developer

August 2014 Present

Confidential

Sr. BI/SQL Web Developer

Confidential

Sr. BI/SQL Developer

Confidential

Sr. SQL Server/BI Developer

Confidential

SQL Server/BI ASP.NET Developer

Confidential

SQL Server Developer / SSRS Developer

Confidential

SQL Server/SSRS Developer

Confidential

SQL Developer/SSRS Developer

Confidential

Sr. BI/SQL Web Developer

Description:

• The Service members Civil Relief Act file automation project has been undertaken to ensure that BMO Harris Business is compliant and meets current regulatory changes. The project is the result of an OCC Matter Requiring Attention MRA and a SCRA Examination.
• The Service members Civil Relief Act , formerly known as the Soldiers' and Sailors' Civil Relief Act SSCRA , is a federal law that provides protections for military members as they enter active duty. It covers issues such as rental agreements, security deposits, prepaid rent, eviction, installment contracts, credit card interest rates, mortgage interest rates, mortgage foreclosure, civil judicial proceedings, automobile leases, life insurance, health insurance and income tax payments

Responsibilities:

• Involved in complete Software Development Life Cycle SDLC process by analyzing business requirements and Understanding the functional work flow of information from source system to destination system
• Advanced extensible reporting skills using SQL server Data Tool 2012 SSRS
• Designed and created Report templates based on the financial data
• Developed various types of Complex reports like Drill Down and Drill through reports
• Involved in designing Parameterized Reports for generating Adhoc reports as per client requirements
• Coordinate with front-end for implementing logic in stored procedure and functions
• Experienced in writing Complex SQL Queries, Stored Procedure, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Function to implement the business logic and also created clustered and non-clustered Indexes
• Developed an SCRA web site
• Developed Questionable, Error Response, Reports and Admin modules for SCRA website
• Developed secure web application, which includes login form, which will authorize and authenticate the users by retrieving their login names and passwords from the database using ADO.Net
• Developed User Control according to the requirement
• Used ADO.net Connection Oriented and disconnected Architecture for database connectivity
• Extensively used ADO.Net objects to populate Data sets, Data grid and Repeater controls for display and manipulation of records
• Created a simple, aesthetic and consistent User Interface with shortcuts, menus, forms and controls in VB.NET
• Dealt with complex design and maintenance issues for SQL by implementing atomicity, consistency, isolation and durability
• Used Data Grids, Data Sets, Data Views, and Data Adaptors to extract data from the backend
• Worked extensively on web forms and data binding controls like Grid View, Data List and drop down boxes and Mapping page fields to the database fields
• Used Web Forms and Server controls in ASP.Net
• Created Dynamic Controls in web pages
• Developed object interfaces for relational database access from presentation layer
• Created session objects to maintain session between ASP.NET Pages
• Successfully developed and deployed .NET applications following all coding standards
• Validating the whole functionality
• The system was deployed as an ASP.NET web application by using VB.NET
• Used Agile methodology SCRUM for the development

Environment: T SQL, SQL Server2012, Microsoft SQL Server Management Studio, SQL Server Integration Services SSIS , SSRS, SSAS, VB.Net 4.5 and ASP.Net 4.5

Confidential

Sr. BI/SQL Web Developer

Description:

Pets have a way of bringing people together and that's exactly how Charles Chuck Anderson and Don Tauer met. Their involvement in owning , training and showing German Shepherds, Golden Retrievers, Schipperkes, Border Collies And a mixed breed is how Chuck and Don became acquainted and also became friends

Responsibilities:

• Creating Stored Procedure, User Define Functions, Views, TSQL scripting for complex business logic
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Increased the performance necessary for statistical reporting by 25 after performance monitoring, tuning and optimizing indexes
• Created Alerts for Successful or unsuccessful completion of Scheduled Jobs
• Developed complex Stored Procedures and Views to generate various Drill-through reports and Parameterized Reports using SSRS
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel Spreadsheet and Flat files into SQL Server 2008 Database by using multiple transformations provided by SSIS Such as Data Conversion, Conditional Split, Merge and Union all scheduled and maintained nightly and Weekly load of data by creating the corresponding job tasks
• Deploying the SSIS packages and SSRS reports on the server
• Created ASP.Net web pages using VB.Net
• Worked with Master Pages
• Design the subpages for Chuck and Dons websites using HTML and CSS for developing Web pages
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation
• The code behind is implemented in VB.net
• Experience in working on conceptual, Physical and logical data models using Visio Data Modeling
• Used Grid View, Form view to display data with a rich look and feel
• Used VSS to manage the source code
• Used Agile methodology SCRUM for the development

Environment: T SQL, SQL Server2008, Microsoft SQL Server Management Studio, SQL Server Integration Services SSIS , SSRS, SSAS, VB.net and ASP.net

Confidential

Sr. BI/SQL Developer

Description:

Confidential is a not-for-profit, non-stock health services company which, Through its affiliates and subsidiaries, offers a comprehensive portfolio of products and Administrative services to individuals and groups in Maryland, the District of Columbia and Portions of northern Virginia. CareFirst is the parent company of CareFirst of Maryland, Inc., And Group Hospitalization and Medical Services, Inc. CareFirst, Inc., and its affiliates are Governed by a Board of Directors and special statutes regulating the company's business in Maryland, the District of Columbia and Northern Virginia

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008/2012 and SSIS in Business Intelligence Development Studio BIDS and SQL Server Data tools 2012
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data in data warehouse
• Prepared the complex data mapping for all the migrated jobs using SSIS
• Designed SSIS packages to transfer data from flat files to SQL Server Using BIDS and SQL Server Data tools
• Extensively used SSIS transformation such as Lookup, Derived column, Data conversion, aggregate, condition split, SQL task, Script task and Send Mail task etc.,
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLEDB Source Oracle , Excel Spreadsheet to SQL Server 2008 R2/2012
• Performed operations like Data reconciliation, Validation and error handling after Extracting data into SQL Server
• Worked on SSIS package, Import/Export for transferring data from Database Oracle and Text formatted data to SQL Server
• Implementation of MS SQL Server 2008 R2/2012 Management studio to create Complex Stored Procedures, User Defined Functions UDFs views using T-SQL evaluates result for the reports
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services SSRS
• Created SQL server Reports using SSRS 2008
• Identified the data source and defined them to build the data source views
• Creating reports using SQL Reporting Services SSRS for customized and ad-hoc Queries
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. Table, chart and matrix report
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Generated SSRS report using Oracle Database
• Work on projects like Healthy Blue, Medical Loss Ratio and Account Searchlight to generate the reports
• Creation of the various database objects tables/views/stored procedures - in SQL Server 2008
• Performed the optimization, Tuning of the indexes and the queries
• Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts
• Created reports by extracting data from cube
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources
• Improve the performance of a cube by creating aggregations and partition of EGR 3.0 project
• Create few workflows in Informatica to load the data into Oracle tables
• Experience working in HIPAA 4010 and HIPAA 5010
• Generated reports from A.C Cube and Medical Management
• Good experience in writing the MDX queries to pull the data from the cube
• Expert in creating Star schema and Snow Flex cubes using SSAS
• Created Dimension and Measure for the Cube
• Deployed the RDL on SharePoint
• Deployed the business documents on SharePoint
• Generated the reports in SharePoint
• Extensively worked in Oracle SQL, PL/SQL, SQL Plus, Query performance tuning, Created DDL scripts and Database objects like Tables, Views and Indexes
• Experience in working on conceptual, Physical and logical data models using Erwin and Visio Data Modeling
• Used Waterfall methodology for the development

Environment: T SQL, SQL Server2008/2012, Microsoft SQL Server Management Studio, SQL Server Integration Services SSIS , SSRS, SSAS, Informatica, Sql and PL/SQL

Confidential

Sr. SQL Server/BI Developer

Description:

Confidential has grown to become one of North America's leading diversified financial services companies providing banking, wealth management, insurance and capital markets services on a global basis. We demonstrate our vision of always earning the right to be our clients' first choice through our values -- service, teamwork, responsibility, diversity and integrity

Responsibilities:

• Migrated all DTS packages to SQL Server Integration Services SSIS and modified the packages accordingly using the advanced features of SQL Server Integration Services
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations
• Experience working with Transfer SQL Object Task which transfer Objects in SQL Server
• Experience working with Execute Package Task which used to call the Child package or Sub Package from Master Package
• Worked on several transformations in Data Flow including Derived-Column, Script Data Conversion, Conditional-Split and many more
• Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages
• Proficient in implementing all transformations available on the SSIS toolbox, Package Configuration and Logging
• Experience in importing/exporting data between different sources like Access/Excel etc. using SSIS/DTS utility
• Excellent knowledge of using variables and expressions in packages
• Developed complex T-SQL Queries
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors and Triggers to facilitate efficient data manipulation and data consistency
• Created complex conceptual database designs in SQL Server 2008 using various constraints and triggers.
• Schedules the SQL jobs in ZEKE scheduler
• Experience working with Batch jobs to call .Net Code
• Experience working as Team Lead
• Increased query performance, necessary for statistical reporting by more than 25 after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard
• Experience working with applications like Bloomberg Data which contains information like tax free Municipal Bonds from different region like North and Latin America
• Performed Unit Testing and Prepared maintenance plans
• Experience in working on conceptual, Physical and logical data models using Erwin Data Modeling

Environment: T SQL, SQL Server2000/2008, Microsoft SQL Server Management Studio, SQL Server Integration Services SSIS , SSRS, SSAS, DTS

Confidential

SQL Server/BI ASP.NET Developer

Description:

Confidential is a neutral provider of service to parties who are setting personal injury claims .Each year we resolve over 100,000 healthcare obligations for thousands of firms and companies across the country. Our Resolution and Compliance program includes: Healthcare lien Resolution, Medicare Set-Aside MSA , Medicare secondary Payer MSP Consulting and Mandatory Insurer Reporting, and Complex Settlement Administration.

Responsibilities:

• Create SSIS package to clean and load data to data warehouse
• Create package to transfer data between OLTP and OLAP databases
• Create SSIS and used the task to import and export files
• Create, modify, schedule, test and or trouble shoot SQL Server Integration Services SSIS packages, stored procedures, Tables and Views
• Experiences in designing, Creating and processing of Cubes using SSAS
• Scheduling cubes processing from staging Database Tables using SQL Server Agent
• Aggregated the cubes with 40 Performance for better performance
• Processed cubes to perform incremental updates
• Create Reports by extracting data from cube
• SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports
• Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by Using SSRS
• Created report snapshots to improve the performance of SSRS
• Involved in Unit Testing and System Testing of the application
• Analysis and trouble shooting of defects
• Worked in 3T User Interface layer, Business Logic layer and also in the Data Access layer with the SQL Server
• The system was deployed as an ASP.NET web application by using C .NET
• Played an active role in analyzing, documenting and designing the application
• Created ASP.Net web pages using C
• Worked with Master Pages and Cascade style sheets CSS for the web pages.
• Used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database
• Worked on providing security using authentication and authorization techniques
• Experience working with versioning control tool like TFS

Environment: T SQL, SQL Server 2008, Microsoft SQL Server Management Studio, SQL Server Integration Services SSIS , SSRS, SSAS, C .Net, Asp.Net, Visual Studio 2010

Confidential

SQL Server Developer / SSRS Developer

Description:

Confidential a not-for-profit organization headquarters in Newark, is the state's largest health Insurer. Our goal is the same as it has been since1932 - to provide individuals and employer in New Jersey with convenient access to quality health care

Responsibilities:

• Writing of Stored Procedures and Functions using SQL Server 2008 and T-SQL
• Creation of the various database objects tables/views/stored procedures - in SQL Server 2008
• Performed the optimization, Tuning of the indexes and the queries
• Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database
• Experiences in designing, Creating and processing of Cubes using SSAS
• Scheduling cubes processing from staging Database Tables using SQL Server Agent
• Processed cubes to perform incremental updates
• Create Reports by extracting data from cube
• Experiences in Dimensional Modeling
• Experiences in XML scripts
• Create, modify, test, and troubleshoot SQL Server Reporting Services SSRS reports
• Created reports by extracting data from cube
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports
• Analysis and trouble-shooting of defects
• Involved in Unit testing and System Testing for the application
• Create database backups, restore, data replication, and database security
• Worked with HIPAA 4010 and HIPAA 5010
• Experience Working with ICD-9 and ICD-10
• Worked in IBM Open Connect
• Worked with NASCO mainframes to process the Medical claims like E835, E832 and E837
• Used Waterfall methodology for the development

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, SSRS, SSIS, SSAS, Erwin

Confidential

SQL Server/SSRS Developer

Description:

Confidential is a leading Credit referencing company in Confidential . Experian Implements, Customizes VisonPLUS Leading Credit Management System for its customers. I was Involved in customizing MBS Merchant banking System module for FNTF, a leading bank of Confidential . I have enhanced settlement functionality to product level from merchant level.

Responsibilities:

• Gather and analyze business requirements
• Create data models to describe data and relationships between the data
• Create data-related documentation e.g., file descriptions and definitions, entity relationships and attributes, etc.
• Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server 2000/2005
• Create SSIS DTS packages to import/export data to/from data-sources such as flat file, Oracle, DB2, Excel, Access, and XML
• Code Stored Procedures to validate, process data needed to create and update Retail warehouse
• Construct reports using SSRS from OLTP OLAP Databases
• Validate change requests, prepare effort estimates and make appropriate recommendations
• Database planning in relation to physical and logical data architecture
• Develop and implement database and coding standards, improve performance and maintainability of SQL Server databases
• Provide back-end support for functional testing and performance testing

Environment: SQL Server 2005, SQL Server 2000, T-SQL, SSIS, SSRS, SSAS, DTS, VBA-Excel, Oracle 8i/9i, VB.Net, VSS, Windows 2000/XP/2003, OS/390, AIX, Linux

Confidential

SQL Developer/SSRS Developer

Responsibilities:

• Involved in Analysis, Design, Development and Testing phases
• Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL
• Maintenance of the various database objects tables/views/stored procedures - in SQL Server 2005
• Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment
• Used the maintenance Plan for SQL Server 2000 databases to recreate indexes and statistics for the performance
• Design and implementation of Security Model, policies and procedures
• Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool
• Created Snapshot Replication for the Development and Testing Databases across different Servers
• Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts
• Designed and developed complex SSRS reports
• Create ad hoc complex management reports as required
• Design and develop reports using SQL server reporting services
• Configuration of linked servers for user to be used for data exchange
• Created and scheduled jobs and alerts
• Involved in version management of source code using VSS
• Analysis and trouble-shooting of defects
• Involved in designing of reports using SSRS
• Involved in Unit testing and System Testing for the application

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, Microsoft SQL Server Reporting Services