OBJECTIVE

• Manages a diverse technical operations team that builds and maintains automated processes

SUMMARY

• 9 years of experience in development, testing, deployment and maintenance of enterprise - wide information database systems that sourced SQL server 2008/2005/2000 , Oracle 9i/8i and MS Access databases
• Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers and user created data types to provide flexible and reusable modules to be used in WEB technology and client-server Windows technology
• Expertise in creating indexed tables with primary key, foreign key and composite key constraints to maintain referential integrity and to maintain performance
• Expertise in writing and debugging Stored Procedures and Triggers
• Hands on experience in the ETL processes using SQL Server Integration Services (SSIS), Bulk Copy Program (BCP) and Data Transformation Services (DTS)
• Strong analytical skills for the understanding and implementation of business logic by designing control flow tasks, dataflow tasks, work flow tasks and applying Extract, Transform, and Load strategies using SQL Server Integration Services.
• Expertise in creating, configuring SSIS and DTS packages for data conversion and data migration from OLTP systems to data warehouse
• Proficient in extraction, transformation, cleansing, and loading data from heterogeneous data sources of Oracle, MS Access and flat files
• Expertise in generating Ad hoc reports, tabular reports, Matrix reports, Drill-down reports, Cascaded reports, List reports, Parameterized reports, Sub reports and mentoring end user report writers
• Experienced in developing user reports, management reports along with Report Authoring, Report management, Report delivery and Report security using SQL Server Reporting Services from MS Excel and flat files
• Extensively involved in SQL Tuning using SQL Server Profiler, SQL TKProf, Explain Plan, Optimizer Experience in managing Alerts, Operators and Jobs through CA Schedular
• Involved in administrative tasks such as creating user roles, logins, security and permission on database level.
• Integrator of relational databases like SQL Server, ORACLE, Microsoft Access and Excel spreadsheets.
• Supported team in resolving SQL Reporting services and T-SQL related issues.
• Good knowledge in transformation of data between databases using Bulk Insert Tasks, Data Pump Tasks
• Expert in building batch process with DOS command to generate reports and send it to users
• Involved in complete life cycle of the project and experience in interacting with end users right from collecting requirements to production support.
• Positive attitude towards superiors & peers.
• Quick learner and good performer both in team and independent job environments.
• Active Participant in knowledge sharing.
• Good Team player and having excellent communication Skills.

TECHNICAL SKILLS

RDMS: SQL Server 2008/2005/2004 , MS Access, Oracle 9i/8i

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Query Analyzer, SQL Profiler, SQL Server Agent, Enterprise Manager

Reporting Tools: SQL Server Reporting Services2008/2005, Crystal reports, ProClarity

Integration Tools: SQL Server Integration Services 2008/2005, DTS, BCP

Operating Systems: Windows NT/95/98/2000/ XP/7

Languages: T-SQL, SQL, VB Script and Dos Command

PROFESSIONAL EXPERIENCE

Confidential, Oaks Pennsylvania

SQL Server and BI Developer

Responsibilities:

• Worked with team of Business Analysts to develop business requirements and identify the scope of the project.
• Analyzed and translated the business requirements into logical and physical architecture of the database.
• Modified current database by adding tables and relationships to support online system.
• Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Implemented complex business logic by creating and modifying complex TSQL batches, Stored Procedures and Functions to support efficient data storage and manipulation.
• Created DML triggers to determine when any sales order exceeds the threshold value and display a message to entitle the customer for discount.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008 with Visual Studio 2010.
• Experience in designing reports for the end user by creating multiple operational Drill-through and Drill-down, parameterized, cascaded, Matrix type reports and Charts using SSRS.
• Prepared ad-hoc reports using Report builder for one time use.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• ScheduledReports to run thereports Hourly, Daily, Monthly Accordingto user requirements for the periodic analysis with automated scripts.
• Developed SSIS Data packages that extract/manipulate data from Flat files and store into Database and vice versa.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Developed and executed system migration plans to testing environment by scheduling SSIS packages for compliance with system change control requirements
• Documented all the project work in support for maintenance

Environment: SQL Server 2008/2012, SSIS, SSRS, MS Excel, MS Access, VB Script, MS DOS Batch jobs, Windows XP/7

Confidential

SQL Server Developer

Responsibilities:

• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Involved in Database designing and Modeling.
• Involved in database and log backups & restoration, backup strategies, scheduling.
• Created and modified Stored Procedure/TSQL coding, Performance tuning, and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Prepared Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling and SQL Server Enterprise manager.
• Work on Designing, Maintaining & tuning various RDBMS like T-SQL & MS SQL Server 2000/2005/2008 , MS Access databases and strong knowledge of SDLC principles.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updations to improve the query performance.
• Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Created parameterized stored procedures to implement business logic.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler
• Created views on database for better performance and security.
• Developed Stored Procedures and Views are used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions
• Extensively used SQL Reporting Services to generate custom reports. Wrote queries to generate reports for analysis of data. Involved in generating summary reports; Tabular, Matrix, Parameterized and Drill down using SSRS.
• Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
• Created Views to support multiple reports
• Involved in ETL framework standards like error processing, reconciliation, validation.
• Created DTS/SSIS packages for Uploading of Various different format of files and databases to MS SQL Server using Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Developed SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2008 using different transformations; derived column, sort, aggregate
• Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler
• Provide 24X7 on-call support for database failures and problems

Environment: SQL Server 2008 Enterprise Edition, T-SQL, SSIS, SSRS, SharePoint 2007

Confidential

SQL Developer

Environment: Server 2005, SSIS, SSRS, T-SQL, CA Schedule, Vb6.0, VB Script

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Designed SSIS packages to migrate the data from different sources to destination data warehouse and migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS Packages.
• Developed the reports using business intelligence development studio (BIDS) and SQL Server reporting services (SSRS) based on the business logic by implementing efficient stored procedures.
• Designed Fact tables, Dimension tables and scheduled data transfer from real time database to data warehouse and databases.
• Extensively worked on Query Optimization and Performance Tuning of databases.
• Deployed SQL Code and Reports (SQL 2005 Reporting Services) to QA\Dev\Prod.
• Used Report manager to deploy reports and schedule reports. Used role based Security to control access to folders, reports and resources.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access, created and managed new security accounts.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Provided back-end support for functional testing and performance testing.

Confidential

Programmer

Environment: Server 2005, T-SQL, VB6.0, Vb.net, Script

Responsibilities:

• Login Module. Include login in Agent Collection
• Collection Module Include Collection of Cheque, Promise etc.
• Search Module Include Detail of Collected Client Payment detail.
• Work in Progress Module In which report of collection at particular time.
• Status Manager Module In which report of collection at Different Combination.
• Letter Module. In which Detail of Different letter type sent to client.
• Encryption and Decryption (For Collection Based Process)
• This process required an encryption and decryption technique for security purpose for very critical Data of online payment transaction. For this I have written a DLL that uses Crypto com API Function for encrypting and decrypting the data. With the help of extended procedure calling this DLL from server for converting the Data using DLL function.
• Quick Remit (Recording Software).
• Software provides solution for recording the conversation between user and client while on line payment process in collection based process. With a help of Nice API we record all the conversation at Nice Server through Integrated Quick remit Software.
• Agent Tracker System (For Collection Based Process)
• Software provides help to find the daily, monthly and yearly based report for evaluate the performance of Collection based process of Individual, Team leader, Manger and above level

Confidential

Programmer

Environment: Oracle 8I, T-SQL, VB6.0, Crystal Report 9I

Responsibilities:

• Shipping Module Include Invoice, Packing List of export items, BRC and All shipping documents.etc.
• Accounts Module Include Voucher generation, Ledger generation, checks Printing generation etc.
• Personnel Module Include Employee detail, Salary generation, card Punching etc.
• Client Module In which Sales Order, Bill Of Material-BOM (Material Requirement), sales detail, and Sale items Details resides.
• Store Module In which purchase order is maintained like raw purchase, finished purchase, Purchase Inspection, stock (item wise), purchase-billing detail, purchase-returns detail, vendor details resides.
• Production Module In which Fabrication order related to different processes (Cutting, Stitching, Printing, Embroidery, and Washing), Fabrication issue challan, Fabrication receive challan, Fabrication stock (process wise), Fabricators detail.
• Reports. Daily reports, monthly reports & yearly reports related with stock, sales, purchase and packing details.