SUMMARY

• Extensive exposure to all the phases of Software Development Life Cycle such as Analysis, Design, Development, Testing, Implementation and Maintenance for various critical applications
• Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Experience in creating and managing Clustered and Non-Clustered Indexes to improve database performance
• Expert in using SQL Server Agent to Schedule and monitor Jobs
• Advanced Access, Excel and SQL skills. High comfort level with consolidating and joining data using Left and Right Outer Joins, Inner joins, creating formulas, VLookup-Ups and Macros

TECHNICAL SKILLS

RDBMS/DBMS: SQL Server, MS Access, and SQL Plus

Database Tools: SQL Server Data Tools, SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Visual Studio 2010, SQL Server Enterprise Manager, T-SQL

Data Transformation Services: (DTS, SSIS), ODBC, OLAP, AS400 (DB2)

Reporting Tools: SQL Server Reporting Services, MS Excel

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL Server BI/SSIS/SSRS ETL Developer

Responsibilities:

• Designed and developed SSIS packages to transform data from flat data files, DB2, Oracle, Excel, and SharePoint to SQL Server 2008 Data Warehouse.
• Work actively on Data Quality Process to avoid data bypassing in the EDW (Enterprises Data Warehouse) and ETL (Extraction, Transformation and Loading) processes.
• Used SQL Server Integration Services (SSIS) to develop various complex packages with parent child relationships that would collectively extract data from the raw extracts coming from multiple sources to two Staging Areas and finally to the Enterprise Data Source (EDS).
• Added various logic to the packages for different purposes like sanity check of the extracts' format like naming convention, file type etc. to process the file based on the date of recipient of the extracts; and also for checking the time of run of the package to direct the flow of the package
• Monitored the flow of data from the Relational Database to the Company's Data Warehouse. Also responsible for troubleshooting issues, notify the issue to the team, the documentation of issues and its resolution
• Developed SSIS packages by effectively using different types of Blocking, Semi-Blocking and Non-Blocking transformations
• Experienced in creating SSIS packages using different type of Tasks, with Error Handling on control flow task and dataflow Tasks. I used logging to log the events and worked on package configuration to run the package on different servers
• Created Ad Hoc reports with the report builder for the end users and was also involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the management
• Creating drilldown matrices and drill through reports that is details based on parameters like Yearly Sales and Monthly Sales
• Extensive use of T-SQL in writing Stored Procedures, Tables, User Defined Functions, Views and Indexes.
• Used tools like Excel and SQL Server to analyze, query, sort and manipulate data according to defined business rules and procedures.
• Also responsible for transferring data from Production Server to the Development Server occasionally on Incremental Basis for the purpose of checking the consistency in data

Confidential, Irving, Texas

SQLServer BI/SSIS/SSRS ETL Developer

Responsibilities:

• Worked in Agile Environment and gathered Business Requirements to develop the business logic, analyzed and designed database solutions.
• Responsible for developing and optimizing reporting solutions using SQL Server Reporting Services (SSRS) to author, manage, and deliver dynamic and interactive reports
• Designed and implemented a variety of SSRS reports such as Parameterized, Drill Down, SnapShot, Cached, Drill Through, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements using both Tabular and Matrix report formats.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS). Also created Alerts for successful or unsuccessful completion of scheduled jobs
• Defined report layouts and wrote complex queries for reports using SSRS 2008R2.Also developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries and customized reports by adding Filters, Calculations, Prompts and Summaries
• Responsible for scheduling the Subscription of the reports with the Subscription Report Wizard and creating Snapshots of the report as per requirement. Also, implemented Security to the reports using Report Manager.
• Worked on making the reports visually appealing by adding different report formatting options and also provided back-end support for Functional Testing and Performance Testing.
• Involved in Performance Improvement of created reports and deployed reports onto Report Server and SharePoint Server making those reports available for the end users.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse
• Extensively used SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance
• Migration of SSRS reports from SQL 2008R2 to SQL 2012

Confidential, Dallas, TX

REPORTING ANALYST

Responsibilities:

• Created weekly and monthly summary and detailed reporting for customer incidents by type for internal and investor analysis
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project
• Utilized variousSQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Unique keys and Check) to ensure data integrity
• Performed Data Manipulation, Mining/Extraction and Design and also conducted statistical analysis to evaluate risk using statistical and query tools
• Developed and configured reports using the data in data marts to be sent at regular intervals to the investors either through email or in shared folders
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Developed database triggers to enforce data integrity, dependent tasks and for auditing purpose
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler
• Updated the statistics information and managed Clustered and Non-Clustered Indices for improved database performance
• Created Jobs for scheduling SSIS packages in scheduler service and send alerts for successful and unsuccessful completion of Scheduled Jobs
• Created SSRS reports using Report Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts
• Prepared reports associated with the monthly loan activity, payoffs, short sales, and other events to investors

Confidential

JUNIOR BUSINESS ANALYST

Responsibilities:

• Created roles, role hierarchies and managed user registrations and approvals in Oracle User Management
• Monitored security by granting user access and defining application privileges
• Worked with the Business Process Owners, Compliance leads, Project team leads, Developers, and Database Administrators to ensure robust and permanent solutions
• Developed solutions to leverage Oracle user management functionality for the eBusiness Suite and suggest improvements
• Developed custom segregation of duties policies based on the company’s business process
• Conducted detailed conflict analyses and identified conflicts based on company’s segregation of duties policies
• Analyzed the segregation of duties reports by roles and users, showing top risks to the business process owners and recommended the best practice where applicable
• Developed solutions surrounding system administrator functions such as evaluating user access, segregation of duties analysis, profile option management, responsibility design, user function and menu design
• Recommended the best ways to remediate the segregation of duties conflicts identified
• Configured and modified the Application Configuration as required (includes system setups, flex-fields, workflow builder, custom library, profile options etc.)
• Assisted internal and external audit staff with problems and resolved issues independently
• Provided workshops and training for knowledge transfer