SUMMARY

• Nine (9) years of experience on Software Systems analysis/ design/ development/ testing/ performance optimization and documentation.
• Design, deployment, and maintenance of various Reports in SQL Server 2012
• Extensive Knowledge in SSRS 2008/2012/2014
• Experienced SSRS Developer with experience working on large - scale enterprise projects involving complex business case functions, web integration, and data management.
• Extensive experience in SSAS
• Created SSIS jobs and packages and executed those tasks.
• Proficient in using Crystal Decision, Crystal Management Console, Crystal Configuration Manager, Crystal Repository, Crystal Migration Wizard and Crystal Publishing Wizard for publishing reports on the Intranet.
• In-depth knowledge in working and implementation of Crystal Decisions & Crystal Reports 7.0/8.0/9.0/10/XI.
• Strong experience in T- SQL development with MS- SQL
• Extensive experiences in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2005/2008/2012
• Highly motivated, reliable analytical problem solver and troubleshooter with strong attention to detail.
• Possess excellent written and oral communication skills with a result-oriented attitude
• Exposed to each of the phases of Software Development Lifecycle (SDLC) and experienced to work as a team member as well as an individual performer under the large development groups.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• DTS applications moving data between different types of databases and legacy systems
• Experienced in data modeling tools, e.g., Erwin.
• Capable of working under Pressure and reach milestones.

TECHNICAL SKILLS

Software/Hardware: SQL Server 2008/12,MS Reporting services 2005/2008/2012, Sharepoint 2007/2013 Crystal Reports 9.0/10/X1, Crystal Enterprise Manager X1 R2, Central management console, SQL Analyzer, Visual Studio 2012, SSRS, SSAS, SSIS, Enterprise Manager, Erwin, Oracle Developer (Forms and Reports), Oracle Tools and Oracle Utilities, PL/SQL, Oracle 9i Application Server, Oracle Procedure Builder, TOAD 6.0, Microsoft Products (MS Word, MS Excel, MS Access, MS Power Point, MS Project), HTML.

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

SQL BI Developer/Admin

Responsibilities:

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Developed SSIS ETL packages to meet data flow needs.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Created Parameterized reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Worked with SSAS cube to define dimension, facts, attribute hierarchy & user defined hierarchy.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs & building platform with the using of SSIS.
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control with the using of Team Foundation Server.
• Used Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases and deadlock issues, best practices in structuring SQL Queries, debugging

Environment: MS SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MDM(Master Data Management)Business Intelligence Development Studio (BIDS), SharePoint 2013, MS Excel, Windows XP, Crystal Reports, Business Objects .John

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Responsible for new database design and implementation
• Created Database Objects - Tables, Indexes, Views, and Roles
• Created complex store procedure to copy Database Objects from remote server to local machine and vice versa
• Responsible for monitoring and tuning T-SQL performance
• Fine tuned database objects and server to ensure efficient data retrieval
• Responsible for migration of SQL objects to production from test environment
• Responsible for planning and designing of SSIS package for data refresh purpose
• Create new and improve existing database reports using SQL Reporting Services 2005
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
• Created SSIS jobs and packages and executed those tasks
• Created reports with different type of properties like chart controls, filters, SQL parameters etc
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Identified and defined datasets, added parameters for the report generation and wrote the queries for the drill down reports.
• Provide required reports from production environment to other departments on request basis and perform data analysis to provide management
• Modified report content and export reports in multiple formats based on user input
• Created numbers of complex formula in sub report using different type of variables likes shared variable and retrieved them from master report
• Designed, developed, modified and enhanced the database structures and database objects
• Updated project status reports/created issue items for reviews/updated technical and transformation files on timely basis.
• Created sites in MS Sharepoint server 2007 according to user requirements
• Created lists, Document folders alerts in MS Sharepoint server
• Deployed reports and manged datasources to the SSRS 2005 reports
• Responsible to send alerts and schedule reports is MS Sharepoint Server
• Responsible for unit testing of code designed in QA and Production.
• Planned, defined and designed data based on the business requirement
• Administrator and maintaining Microsoft Office SharePoint Server 2007 and Windows SharePoint Services 3.0/2.0 including customer support and ongoing development.
• Configured MOSS Server Farm and created Web Applications, Site Collections and Sites.
• Installation and setup of the environment of MOSS 2007, Configuration and Maintenance of SharePoint Farm through Central Administration, Configured MOSS Site template based on business requirements
• Created customized workflows in Sharepoint designer according to user requirement.
• Created Stored Procedures, views in SQL Server using T-SQL to collect data for the crystal reports
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports
• Created Packages to group logically related column types and to transfer data

Environment: SQL Server 2008, SQL Integration Services, SQL Server Reporting Services, MS Sharepoint Server 2007,MS Sharepoint Designer, Crystal Reports X

Confidential, Atlanta, GA

MS SQL Server / SSIS /SSRS Developer/Sharepoint

Responsibilities:

• Analyzed CRD and CVO (Historical MS Access Databases) and documented
• Created several prototypes using MS Access
• Created SQL server Reports using SSRS 2005
• Created different levels of drill down charts
• Wrote Different types of Expressions to created complex reports
• Wrote different complex SQL queries
• Created SSIS jobs and packages and executed those tasks
• Used SSAS cubes and created parameterized reports
• Created different shared data sources and connected the reports to data sources
• Created Dynamic Drill Down reports
• Created Parameterized and Cascading parameterized reports
• Created matrix reports, drill down reports and developed reports with graphs
• Used Common functions like Aggregate, financial, Date time etc in Development of reports
• Involved in Sharepoint user management such as configuring user permission level and various users group permissions and adding users accordingly.
• Well versed with List, Views, Web Parts, Configuring workflows, CotnentType, SiteColumns etc.
• Involved in planning for Back-Up System/Disaster recovery, well versed working with STSADM Commands.
• Experience in deploying Features and Solutions in SharePoint.
• Proficient at workflows using the out-of-the-box or custom designed using SharePoint Designer 2007.
• Configured out-of-the-box and custom web parts to interact with MOSS 2007 lists, libraries, BDC and other data sources.
• Wrote .NET embedded code for custom constants
• Wrote .NET code and handled the custom functions
• Deployed reports to the report server and managed the reports
• Developed windows schedule tasks for different data pulls and directly populate data to SQL Server by creating several ODBC connections
• Used XML for exchanging information in different modules of the application
• Managed documents and records using Sharepoint ECM
• Created several test cases and involved in system testing
• Responsible to provide production support to the client
• Created different tasks and Work Flows for direct data pulls from DB2 to SQL Server by using Informatica 8.1 tools